Query which Find string and increment the count
<p>I have table like that,</p>

<pre><code> id     name    count
 1      rrr     2   
 2      www     3   
 3      qqq     4   
 4      aaa     5   
 5      gyhhh   4   
 6      dfgdfg  5   
</code></pre>

<p>I want to write the query which find the name in table and if it find then increment the count in count column for that name. The count maintain the no of time name used by the user.If user used the name , then I am check the name in db , if it found then I want to update row with increment in count.</p>