Query which I ran:

mysql> select count(us_name) from table where us_name='samy';
+----------------+
| count(us_name) |
+----------------+
|              6 |
+----------------+
1 row in set (0.00 sec)