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 vote205 views1 answer
MySql Modify Increment
SQL
0 vote196 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote220 views1 answer
Sql select sum group by id laravel join
SQL
0 vote206 views1 answer
Sql server update top n records
SQL
0 vote247 views1 answer
Sql tablo sp
SQL
3 votes206 views6 answers
DB::table('users')->get();
SQL
-1 vote205 views5 answers
Not in sql
SQL
0 vote183 views1 answer
R2dbc-postgresqldriver dependency
SQL
4 votes207 views2 answers
Oracle sql group by date year
SQL
3 votes187 views1 answer
Postgresql cast
SQL