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 vote340 views2 answers
Mysql order by date asc null last
SQL
0 vote381 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes359 views1 answer
Oracle sql day of month from date
SQL
0 vote359 views1 answer
Show database not empty tables postgres
SQL
0 vote315 views1 answer
Now() -1 mysql
SQL
15 votes387 views4 answers
Mysql export database command line
SQL
0 vote352 views1 answer
Excute raw query
SQL
-2 votes352 views1 answer
Remove root password mysql
SQL
15 votes353 views3 answers
Find duplicate keys in mysql
SQL
1 vote371 views1 answer
Oracle apex version view
SQL