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

37 votes130 views3 answers
Postgresql insert column
SQL
15 votes269 views2 answers
Sql order by alphabetical
SQL
2 votes142 views1 answer
Sql finding longest and shortest names in a fleld
SQL
3 votes222 views1 answer
Ssh check mysql version
SQL
3 votes161 views1 answer
Export postgres database linux
SQL
17 votes141 views3 answers
Postgresql version command
SQL
0 vote166 views1 answer
Find wordpress version in database
SQL
0 vote139 views1 answer
Neo4j command to run script file
SQL
2 votes134 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote165 views1 answer
Mysql loop through databases and execute query
SQL