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