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

1 vote145 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote151 views1 answer
Set engine to innodb
SQL
7 votes146 views5 answers
Show details of table postgres
SQL
19 votes141 views4 answers
Rename database in sql
SQL
19 votes149 views3 answers
How to change column type psql
SQL
34 votes186 views6 answers
Alter table add foreign key mysql
SQL
0 vote157 views1 answer
Connect postgresql using a connection string
SQL
0 vote155 views1 answer
How to close external sql connection in laravel
SQL
0 vote155 views2 answers
Athena drop partition
SQL
28 votes141 views4 answers
Show tables mysql
SQL