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 vote125 views1 answer
SQL column name Oracle
SQL
1 vote131 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote139 views1 answer
Sql server on mac m1
SQL
0 vote127 views1 answer
Sql count * vs count 1
SQL
17 votes154 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote105 views0 answer
SQL
6 votes125 views3 answers
How to delete table sqlite
SQL
0 vote125 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote121 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote118 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL