mysql> select count(*) from comments where body like "%fuck%"; +----------+ | count(*) | +----------+ | 1917 | +----------+ 1 row in set (0.35 sec) mysql> ----- almost 2000 comments with fuck in em -----