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

49 votes349 views6 answers
Get duplicate records in sql
SQL
1 vote296 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote292 views1 answer
Original Query
SQL
1 vote288 views1 answer
Truncate left characters mysql
SQL
4 votes324 views1 answer
Data types in sql
SQL
1 vote257 views1 answer
Mssql string length
SQL
0 vote312 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
-1 vote287 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
15 votes298 views6 answers
Drop foreign key mysql
SQL
10 votes272 views1 answer
Oracle dependency
SQL