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 vote238 views1 answer
Pl sql drop trigger
SQL
1 vote219 views1 answer
Sql to mongodb query converter
SQL
2 votes168 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote167 views1 answer
Oracle sql developer closed connection
SQL
0 vote181 views1 answer
Mysql remove bad character from all fields
SQL
0 vote227 views1 answer
Month mysql
SQL
10 votes171 views4 answers
Sql pagination
SQL
8 votes159 views3 answers
Postgresql connection string c#
SQL
0 vote166 views1 answer
Sql get number of days between two dates
SQL
0 vote205 views1 answer
Sql select merge multiple values
SQL