String MySQL

  1. Home
  2. MySQL
  3. String
  4. LOCATE(substring, string)
mysql>
mysql> SELECT LOCATE('dogs', 'cats and dogs');
+---------------------------------+
| LOCATE('dogs', 'cats and dogs') |
+---------------------------------+
|                              10 |
+---------------------------------+
1 row in set (0.00 sec)