Mega Code Archive

 

Categories / MySQL / String

 

SELECT LOCATE(A,BINARY abc)

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