mysql>
mysql> SELECT LOCATE('dogs', 'cats and dogs');
+---------------------------------+
| LOCATE('dogs', 'cats and dogs') |
+---------------------------------+
| 10 |
+---------------------------------+
1 row in set (0.00 sec)