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 vote351 views1 answer
Create date sql
SQL
5 votes351 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote356 views1 answer
Sql drop procedure if exists
SQL
0 vote353 views3 answers
Insert query in ci
SQL
0 vote344 views1 answer
Get records in sql according to month name and count
SQL
5 votes308 views1 answer
Postgres upsert
SQL
0 vote353 views1 answer
Select 1 from orders
SQL
25 votes374 views3 answers
How to use a database to see tables mysql
SQL
1 vote432 views2 answers
Coderbyte sql solutions
SQL
2 votes340 views3 answers
Postgres remove foreign key constraint
SQL