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 vote102 views1 answer
How to login to mysql in homestead
SQL
0 vote230 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote125 views1 answer
Select milliseconds mysql
SQL
0 vote120 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote100 views3 answers
Get all tables postgres
SQL
5 votes108 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes111 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote118 views2 answers
List tables sqlalchemy
SQL
0 vote109 views1 answer
Exit psql
SQL
1 vote109 views2 answers
Sql insert timestamp
SQL