{"action":"closed","issue":{"url":"https://api.github.com/repos/rbock/sqlpp11/issues/37","labels_url":"https://api.github.com/repos/rbock/sqlpp11/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/rbock/sqlpp11/issues/37/comments","events_url":"https://api.github.com/repos/rbock/sqlpp11/issues/37/events","html_url":"https://github.com/rbock/sqlpp11/issues/37","id":75765568,"number":37,"title":"How to check if row exists?","user":{"login":"niXman","id":518474,"avatar_url":"https://avatars.githubusercontent.com/u/518474?v=3","gravatar_id":"","url":"https://api.github.com/users/niXman","html_url":"https://github.com/niXman","followers_url":"https://api.github.com/users/niXman/followers","following_url":"https://api.github.com/users/niXman/following{/other_user}","gists_url":"https://api.github.com/users/niXman/gists{/gist_id}","starred_url":"https://api.github.com/users/niXman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/niXman/subscriptions","organizations_url":"https://api.github.com/users/niXman/orgs","repos_url":"https://api.github.com/users/niXman/repos","events_url":"https://api.github.com/users/niXman/events{/privacy}","received_events_url":"https://api.github.com/users/niXman/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":17,"created_at":"2015-05-12T22:40:44Z","updated_at":"2015-05-13T11:48:10Z","closed_at":"2015-05-13T11:48:10Z","body":"Hi,\r\n\r\nI need to check if user 'Bob' exists in the table:\r\n```cpp\r\nCREATE TABLE users(\r\n   id INT PRIMARY KEY,\r\n   nickname varchar(32)\r\n)\r\n```\r\nUsually I would have run the following query:\r\n```cpp\r\nSELECT COUNT(*) FROM users WHERE nickname='Bob'\r\n```\r\nBut I can not understand how to do this using sqlpp11?\r\n\r\nThanks!"}}