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

4 votes301 views2 answers
Xampp mysql database server is not starting mac m1
SQL
4 votes319 views1 answer
Mysql ip address data type
SQL
0 vote321 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote269 views1 answer
Kannst du deine finger trainieren
SQL
36 votes338 views6 answers
Delete from where sql
SQL
8 votes325 views1 answer
Oracle search code in packages
SQL
4 votes295 views2 answers
DB::transaction
SQL
1 vote296 views1 answer
How to select department from table
SQL
0 vote311 views1 answer
Sql create text column limited values
SQL
0 vote320 views1 answer
Copy value from one column to another postgres
SQL