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 vote173 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote181 views2 answers
Raise notice in postgresql function
SQL
0 vote163 views1 answer
Sql server 2012 create or alter procedure
SQL
6 votes173 views2 answers
Find mysql version linux
SQL
5 votes170 views1 answer
Ascending order and where in sql
SQL
13 votes170 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
5 votes166 views3 answers
Sql make column nullable
SQL
0 vote162 views1 answer
Login phpmyadmin without password
SQL
0 vote166 views2 answers
Getting customers with no orders sql
SQL
0 vote169 views1 answer
Order by ip address sql
SQL