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

1. MySQL Tutorial
2. String Functions
3. INSTR

mysql>
mysql> SELECT INSTR('ABCDE', 'AB');
+----------------------+
| INSTR('ABCDE', 'AB') |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT INSTR('ABC', 'DEF');
+---------------------+
| INSTR('ABC', 'DEF') |
+---------------------+
|                   0 |
+---------------------+
1 row in set (0.00 sec)

mysql>