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

14 votes252 views2 answers
Sql cast
SQL
5 votes244 views1 answer
Oracle ora-00054 causes
SQL
0 vote251 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote244 views1 answer
Declarative base sqlalchemy
SQL
2 votes250 views1 answer
Oracle trace session
SQL
0 vote253 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
3 votes273 views1 answer
Sql online test questions and answers
SQL
0 vote239 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
10 votes238 views3 answers
Sql limit results
SQL
12 votes250 views4 answers
Install mysql ubuntu 18.04
SQL