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 vote154 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote129 views1 answer
Mysql where in maintain order
SQL
0 vote129 views1 answer
Create database store
SQL
0 vote121 views1 answer
Changer un mot de passe mysql
SQL
0 vote133 views1 answer
Sql ignore
SQL
0 vote184 views1 answer
Sql select max value for each group
SQL
0 vote77 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
-1 vote141 views3 answers
PS5
SQL
27 votes124 views5 answers
Add column in table
SQL
0 vote136 views1 answer
Docker open terminal mysql server
SQL