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 vote221 views1 answer
Install ms sql server management studio
SQL
0 vote144 views1 answer
Sql script to remove default from column
SQL
25 votes152 views6 answers
How to change column name in mysql
SQL
1 vote149 views1 answer
Full sql mode
SQL
-1 vote135 views1 answer
Io
SQL
1 vote132 views1 answer
Find a column in all tables postgres
SQL
2 votes147 views2 answers
Sqlalchemy return id after insert
SQL
0 vote150 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote171 views1 answer
Prisma transaction
SQL
0 vote141 views1 answer
Sqlplus change user
SQL