FIND_IN_SET sql query
<p>I have query like below.</p>

<pre><code>SELECT Id, FIND_IN_SET('22', Category ) &gt;0 AS `tot_cat` 
FROM tbl_doctorprofile
</code></pre>

<p>I am getting result 1 in which row i am getting value '22' else 0..
so result is like below.</p>

<pre><code>Id tot_cat
----------
1    0
2    0
3    1
4    0
</code></pre>

<p>But i want only count of rows which has value 1.</p>