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

10 votes321 views2 answers
Reset mysql root password mac
SQL
0 vote333 views2 answers
Update all columns in one update
SQL
5 votes301 views2 answers
Create table
SQL
-1 vote371 views2 answers
Sql search all tables for attributes
SQL
1 vote340 views1 answer
Mysql show database size in mb
SQL
0 vote320 views1 answer
Uuid sqlalcomany
SQL
0 vote338 views1 answer
Mysql 8 error on identified by
SQL
0 vote333 views1 answer
Sql server alter table column nullable
SQL
3 votes344 views4 answers
Order by desc postgres
SQL
0 vote316 views1 answer
Psql no such file or directory
SQL