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






  1. SQL / MySQL
  2. String
  3. LOCATE

LOCATE(, )

    
mysql>
mysql> SELECT LOCATE('dogs', 'cats and dogs');
+---------------------------------+
| LOCATE('dogs', 'cats and dogs') |
+---------------------------------+
|                              10 |
+---------------------------------+
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');