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 vote202 views1 answer
Sql server separar numeros por comas miles
SQL
-2 votes199 views2 answers
Sqlserver docker
SQL
1 vote203 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote235 views1 answer
SQL SERVER xquery count child nodes
SQL
2 votes269 views1 answer
Creating a view SQL
SQL
0 vote247 views1 answer
Oracle swap partition
SQL
0 vote215 views1 answer
Selecting all columns from table sql database
SQL
0 vote188 views1 answer
Postgresql like
SQL
7 votes202 views2 answers
Sql server drop temp table if exists
SQL
0 vote193 views5 answers
Mode sql course
SQL