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 vote110 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote124 views1 answer
Oracle list datafiles
SQL
0 vote134 views1 answer
FIND most frequent word in sql server
SQL
5 votes129 views1 answer
Get table columns from sql
SQL
1 vote111 views1 answer
Column with prefix in sql
SQL
0 vote116 views1 answer
Tsql generate rows
SQL
0 vote128 views1 answer
Postgresql print sessions using the database
SQL
0 vote111 views1 answer
Hibernate with springboot mysql
SQL
0 vote118 views1 answer
Sql contains numeric characters
SQL
2 votes122 views1 answer
Sql update alias
SQL