Mysql POSITION
From w3cyberlearnings
Contents |
MySQL POSITION Function
This function is a synonym for Locate(substr,str) function.
Syntax POSITION
- Substr: substring to look for
- Str: String that may contain Substring.
POSITION(Substr IN Str);
Example 1
mysql> SELECT POSITION('go' IN 'we go to them');
+-----------------------------------+
| POSITION('go' IN 'we go to them') |
+-----------------------------------+
| 4 |
+-----------------------------------+
1 row in set (0.00 sec)
