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 vote337 views1 answer
Delete first row in sql
SQL
1 vote324 views1 answer
Select if then postgresql
SQL
0 vote311 views1 answer
Mysql money value
SQL
7 votes340 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote337 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
2 votes335 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
1 vote314 views1 answer
Sql auto date
SQL
6 votes310 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote327 views1 answer
How many rows affected in sqllite
SQL
0 vote326 views1 answer
Sql select max value for each group
SQL