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 vote387 views3 answers
Sql subquery
SQL
0 vote244 views3 answers
CONTACT FORM SQL
SQL
0 vote243 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
4 votes271 views6 answers
Select sql
SQL
2 votes242 views1 answer
Add new column not null sql server
SQL
3 votes230 views4 answers
Mysql create table from select statement
SQL
0 vote235 views1 answer
Template MySQL Zabbix agent
SQL
0 vote251 views2 answers
Mysql two column combination unique
SQL
0 vote232 views1 answer
Sql mod even odd
SQL
0 vote278 views1 answer
Sql create and grant user access to database
SQL