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 vote155 views1 answer
How to generate ids in sql
SQL
0 vote158 views1 answer
How to find symmetric pairs in sql
SQL
16 votes157 views3 answers
Update table from another table
SQL
2 votes150 views1 answer
Pandas to sql index
SQL
0 vote117 views1 answer
Oracle sql replace string in clob
SQL
4 votes105 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
1 vote159 views1 answer
Oracle sql first day of year
SQL
1 vote144 views2 answers
String to date postgres
SQL
0 vote182 views1 answer
Mysql best varchar length size
SQL
0 vote188 views1 answer
Mysql subtract month from timestamp
SQL