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 vote152 views1 answer
How to check table exists or not in postgresql
SQL
0 vote154 views1 answer
Sql delete from with relation
SQL
0 vote173 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote144 views1 answer
Oracle tablespace autoextend
SQL
0 vote164 views1 answer
Vbscript clean up ADODB.Recordset
SQL
5 votes159 views1 answer
Mysql count lines
SQL
4 votes161 views6 answers
Second max salary in sql
SQL
0 vote158 views1 answer
Mysql replication change database name
SQL
0 vote175 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote156 views1 answer
How to reset the database value in SQL server
SQL