LOCATE(, , ) : LOCATE « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. LOCATE

LOCATE(, , )

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








Related examples in the same category

1.LOCATE(, )
2.SELECT LOCATE('A','abc');
3.SELECT LOCATE('A',BINARY 'abc');