[MySQL] LOCATE()

MySQL 문자열 함수와 연산자

 

LOCATE()

   -

 

LOCATE(substr, str)

LOCATE(substr, str, pos)

의 형태

 

The first syntax returns the position of the first occurence of substring substr in string str. The second syntax returns the position of the first occurence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str. Returns NULL if any argument is NULL.

 

mysql> SELECT LOCATE('bar', 'foobarbar');
+----------------------------+
| LOCATE('bar', 'foobarbar') |
+----------------------------+
|                          4 |
+----------------------------+
1 row in set (0.00 sec)

mysql> SELECT LOCATE('xba4', 'foobar') ;
+--------------------------+
| LOCATE('xba4', 'foobar') |
+--------------------------+
|                        0 |
+--------------------------+
1 row in set (0.00 sec)

mysql> SELECT LOCATE('bar', 'foobarbar', 5) ;
+-------------------------------+
| LOCATE('bar', 'foobarbar', 5) |
+-------------------------------+
|                             7 |
+-------------------------------+
1 row in set (0.00 sec)