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 vote351 views1 answer
Oracle duration between timestamps
SQL
0 vote287 views1 answer
Copy table dbeaver
SQL
0 vote342 views1 answer
How to change the field size of an existing column
SQL
6 votes335 views2 answers
WHERE value IS sql
SQL
0 vote362 views1 answer
Update having mysql
SQL
1 vote330 views1 answer
Crontab every month
SQL
1 vote349 views1 answer
How to group by month using sql server
SQL
1 vote356 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote420 views1 answer
Select * from mysql.proc
SQL
4 votes354 views6 answers
Second max salary in sql
SQL