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

8 votes225 views1 answer
Oracle search source code
SQL
0 vote216 views1 answer
Raiserror nowait sql server
SQL
1 vote234 views2 answers
Copy database mysql
SQL
0 vote234 views1 answer
Linebreak sql
SQL
9 votes228 views5 answers
Sql limit
SQL
4 votes221 views4 answers
Update select mysql
SQL
-1 vote239 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote234 views1 answer
Stored function in sql
SQL
0 vote270 views1 answer
Mysql streaming example
SQL
1 vote222 views1 answer
Tsql random number
SQL