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

2 votes328 views2 answers
Python escape string for sql
SQL
2 votes281 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
-2 votes261 views3 answers
Sqlite reset autoincrement
SQL
5 votes271 views3 answers
Day of week postgresql
SQL
1 vote275 views1 answer
Sql padd let with zeros
SQL
2 votes302 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote275 views1 answer
Sql select max value for each group
SQL
3 votes260 views4 answers
Mysql create table from select statement
SQL
1 vote277 views2 answers
Postgres cast as decimal
SQL
7 votes319 views1 answer
Show line number in sql server
SQL