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 vote181 views1 answer
How to connect to mysql in ef 6
SQL
0 vote189 views2 answers
Null value in column violates not-null constraint
SQL
0 vote185 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote185 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote199 views1 answer
Reset keys in sql
SQL
1 vote198 views1 answer
Mysql current time
SQL
0 vote202 views1 answer
Setval in postgres
SQL
5 votes187 views2 answers
Ranking functions in sql
SQL
0 vote196 views3 answers
Postgresql grant alter table to user
SQL
3 votes187 views1 answer
Force using index plsql
SQL