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

-1 vote389 views4 answers
Full outer join in sql
SQL
1 vote353 views1 answer
Group_concat max length mysql
SQL
0 vote337 views3 answers
Insert query in ci
SQL
11 votes335 views2 answers
Turn off safe mode mysql
SQL
0 vote331 views1 answer
Sql select by content lenght
SQL
2 votes407 views3 answers
Sql delete duplicate
SQL
6 votes423 views2 answers
Install psql mac
SQL
1 vote369 views1 answer
Print all records of table in mysql
SQL
0 vote322 views1 answer
Soql more than today
SQL
0 vote356 views1 answer
Oracle list of long running queries
SQL