from http://peter2009.iteye.com/blog/1181789
LOCATE(substr,str)
返回子串substr在字符串str第一个出现的位置,如果substr不是在str里面,返回0.
- mysql> select LOCATE('bar', 'foobarbar');
- -> 4
- mysql> select LOCATE('xbar', 'foobar');
- -> 0
from http://peter2009.iteye.com/blog/1181789
LOCATE(substr,str)