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 vote268 views1 answer
Sql server epoch to datetime
SQL
0 vote287 views1 answer
One table with another
SQL
0 vote282 views2 answers
Call to undefined function mysql_query()
SQL
0 vote278 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
3 votes281 views2 answers
Update Query in SQL Server
SQL
-1 vote256 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote274 views1 answer
How to check which table has data in mysql
SQL
4 votes275 views1 answer
Conda install sqlalchemy
SQL
0 vote282 views1 answer
Tsql delete all rows
SQL
0 vote266 views1 answer
C# mysql update statement set value to null
SQL