INSTR(, ) identifies where the substring is located in the string and returns the position : INSTR « String « SQL / MySQL

1. SQL / MySQL
2. String
3. INSTR

INSTR(, ) identifies where the substring is located in the string and returns the position

   
number.
mysql>
mysql>
mysql> SELECT INSTR('cats and dogs', 'dogs');
+--------------------------------+
| INSTR('cats and dogs', 'dogs') |
+--------------------------------+
|                             10 |
+--------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
  

Related examples in the same category