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 vote204 views1 answer
Min salary in sql
SQL
0 vote205 views1 answer
Sql select min row
SQL
6 votes239 views4 answers
Mysql group by date
SQL
2 votes231 views2 answers
Mysql search for column name in all tables
SQL
0 vote247 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote239 views3 answers
Condition in count sql
SQL
14 votes216 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote352 views1 answer
Sql change a colum to unique
SQL
0 vote194 views1 answer
Get only first row mysql
SQL
3 votes222 views2 answers
Sql select data from last week
SQL