SELECT LOCATE('A','abc'); : LOCATE « String « SQL / MySQL






SELECT LOCATE('A','abc');

    
mysql>
mysql> SELECT LOCATE('A','abc');
+-------------------+
| LOCATE('A','abc') |
+-------------------+
|                 1 |
+-------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
  








Related examples in the same category

1.LOCATE(, )
2.LOCATE(, , )
3.SELECT LOCATE('A',BINARY 'abc');