Name
INSTR( )
Synopsis
INSTR(string,substring)
This function returns the starting position of the first occurrence
of the substring. The index of the first
position is 1. This function is case-insensitive unless the argument
is a binary string.
SELECT INSTR('Where are you?', 'you')
AS 'INSTR( ) Test';
+--------------+
| INSTR( ) Test |
+--------------+
| 11 |
+--------------+Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
