LOCATE(substr,str): Returns the position of the first occurrence of substring substr in string str : LOCATE « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. LOCATE

Returns 0 if substr is not in str.

mysql>
mysql> SELECT LOCATE('ABC', 'ABCABC');
+-------------------------+
| LOCATE('ABC', 'ABCABC') |
+-------------------------+
|                       1 |
+-------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT LOCATE('AA', 'AABBCCDD');
+--------------------------+
| LOCATE('AA', 'AABBCCDD') |
+--------------------------+
|                        1 |
+--------------------------+
1 row in set (0.00 sec)