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 vote165 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote181 views1 answer
Create new table from old table with data
SQL
4 votes117 views1 answer
Adding data to table in sql python
SQL
6 votes116 views2 answers
Sql display max value
SQL
0 vote102 views3 answers
Mysql delete if not in another table
SQL
0 vote117 views4 answers
Open mysql port bitnami tomact
SQL
0 vote146 views1 answer
Psql create usr
SQL
0 vote109 views1 answer
Write sql query to show the details start from digit
SQL
3 votes106 views1 answer
How to check schema privileges in oracle
SQL
0 vote107 views1 answer
Flask sqlalchemy remove duplicates
SQL