Mysql locate

/*return position of substring in string: 0 is no match, 1=start of string*/
SELECT LOCATE("world", "hello world"); 

/*will return position of bob in full_name, 
0 means no bob in full_name. 1 means full_name starts with bob */
SELECT LOCATE("bob", full_name) as bob_position from users;

Similar codes

50 votes290 views6 answers
Sql count duplicate rows
SQL
0 vote196 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote203 views1 answer
Alter add syntax
SQL
1 vote202 views1 answer
Show all event schedular on mysql
SQL
0 vote212 views1 answer
Mysql wait_timeout
SQL
0 vote215 views1 answer
Mysql user set plugin
SQL
1 vote217 views1 answer
Regular expression in sql server
SQL
0 vote166 views0 answer
SQL
0 vote216 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
-1 vote203 views1 answer
Condition in orderby mysql
SQL