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

25 votes168 views6 answers
Modify column name in mysql
SQL
0 vote171 views1 answer
Drop a field in psql django
SQL
1 vote166 views1 answer
Delete row mssql
SQL
0 vote195 views1 answer
To Create directory
SQL
0 vote189 views1 answer
Mysql select all where count more than"
SQL
0 vote168 views1 answer
Install mysql 8 linux
SQL
0 vote206 views1 answer
000webhost database values insert
SQL
0 vote186 views1 answer
Docker open terminal mysql server
SQL
16 votes175 views1 answer
Mysql mediumint max value
SQL
2 votes280 views2 answers
How to DROP a table in mysql
SQL