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 vote114 views1 answer
Kill thread
SQL
0 vote123 views1 answer
How to add timestamp column in mysql
SQL
1 vote164 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
2 votes123 views2 answers
Create empty table from existing table
SQL
1 vote121 views1 answer
Timestamp in sqlite
SQL
3 votes119 views3 answers
Create table in microsoft sql server
SQL
0 vote116 views1 answer
Cross apply top for each row t1
SQL
0 vote103 views1 answer
Sqlite to csv statement
SQL
14 votes125 views2 answers
Install mysqldump
SQL
4 votes146 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL