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 vote137 views1 answer
Postegresql update to null
SQL
0 vote131 views1 answer
Acutal month year
SQL
2 votes97 views1 answer
Sql float to int
SQL
0 vote154 views1 answer
Oracle chain step succeeded
SQL
5 votes148 views2 answers
Create function postgresql
SQL
3 votes97 views1 answer
Postgresql where current year
SQL
0 vote172 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote196 views1 answer
Tsql find procedure with name
SQL
1 vote159 views1 answer
How to delay stored procedure execution in sql server
SQL
3 votes133 views1 answer
Oracle wait
SQL