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

9 votes186 views3 answers
Mysql show table column full description
SQL
1 vote179 views1 answer
Postgres check blocking
SQL
0 vote180 views1 answer
Sql convert datetime to year
SQL
1 vote185 views1 answer
Oracle sql create or replace view
SQL
3 votes194 views1 answer
Oracle get trigger ddl
SQL
2 votes193 views2 answers
Mysql find max value row
SQL
1 vote182 views1 answer
Mamp mysql path mac
SQL
3 votes192 views2 answers
Create schema postgres
SQL
0 vote182 views1 answer
Doesn't have default value mysql
SQL
0 vote188 views1 answer
Normalization in database
SQL