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

10 votes334 views6 answers
Mysql set root password
SQL
0 vote292 views2 answers
PostgreSQL having
SQL
50 votes360 views6 answers
Sql duplicate rows
SQL
0 vote275 views1 answer
Implicit inner join table alias with id values
SQL
2 votes274 views1 answer
Mysql select random id from table
SQL
0 vote286 views1 answer
Drop a field in psql django
SQL
0 vote290 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
-2 votes276 views1 answer
How to open database
SQL
0 vote286 views1 answer
Recover deleted data from mysql database
SQL
1 vote275 views1 answer
Add sequence postgres
SQL