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

0 vote184 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote248 views1 answer
Opensuse start MySQL
SQL
1 vote194 views1 answer
Sql row having max
SQL
0 vote186 views1 answer
How to put value in parameters in mysqldataadapter
SQL
6 votes260 views1 answer
How to count number of rows in sql
SQL
0 vote166 views1 answer
Sql beginning of previous month
SQL
0 vote198 views1 answer
Sql remove non numeric characters
SQL
0 vote178 views1 answer
T-sql email validation
SQL
0 vote178 views1 answer
Sql query for getting data with join and count
SQL
0 vote192 views1 answer
How to create a new db from dumb file mysql
SQL