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 vote244 views1 answer
Count column of tables psql
SQL
13 votes265 views3 answers
Mysqldump structure only
SQL
0 vote203 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
14 votes237 views6 answers
Finding duplicate rows mysql
SQL
0 vote203 views2 answers
Sql trigger difference between for and after
SQL
0 vote196 views2 answers
Auto increment column in mysql query results
SQL
4 votes259 views1 answer
Oracle change nls_date_format permanently
SQL
1 vote253 views3 answers
Nth highest salary
SQL
0 vote204 views1 answer
Sql include rows with 0 values
SQL
1 vote199 views1 answer
Primary key with prefix sql
SQL