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

0 vote191 views2 answers
Raise notice in postgresql function
SQL
0 vote212 views2 answers
Impala rename column name
SQL
0 vote173 views1 answer
Object Information
SQL
2 votes189 views2 answers
Postgres select duplicate columns
SQL
0 vote173 views1 answer
Alter table name including schema
SQL
6 votes166 views2 answers
Return columns from table sql
SQL
2 votes179 views1 answer
How to make insert script from table in SQL server
SQL
0 vote178 views1 answer
Sql server information_schema temp tables
SQL
0 vote191 views1 answer
Mysql update set sum
SQL
1 vote202 views1 answer
Group_concat order by
SQL