mysql locate

1POSITION(substr IN str)
2

1/*return position of substring in string: 0 is no match, 1=start of string*/
2SELECT LOCATE("world", "hello world"); 
3
4/*will return position of bob in full_name, 
50 means no bob in full_name. 1 means full_name starts with bob */
6SELECT LOCATE("bob", full_name) as bob_position from users;