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 vote136 views1 answer
Create new table pl sql
SQL
0 vote161 views1 answer
Sql server isnull function nor working count
SQL
1 vote148 views1 answer
Md5 encryption for existing records
SQL
1 vote156 views1 answer
Decalre temp table sql
SQL
8 votes195 views1 answer
Insert a select statement into a table
SQL
4 votes154 views1 answer
Refresh postgres config
SQL
1 vote163 views1 answer
Postgresql float 2 decimal places
SQL
0 vote240 views3 answers
Osx stop mysql service
SQL
32 votes152 views6 answers
Sql count where
SQL
1 vote220 views1 answer
Oracle see column type
SQL