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 vote310 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
2 votes286 views1 answer
How to insert string variable into sqlite database
SQL
0 vote261 views1 answer
How to count with except in psql
SQL
31 votes269 views3 answers
Sql count(*)
SQL
1 vote301 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
2 votes273 views1 answer
No data found oracle
SQL
3 votes282 views2 answers
Sql get month name
SQL
1 vote270 views1 answer
Mysql sort by date column
SQL
0 vote292 views1 answer
Mysql where in maintain order
SQL
1 vote287 views2 answers
Mysql between
SQL