STRCMP()
STRCMP :
We can use STRCMP() in mysql for compare to strings.
It returns 0 if the strings are the same, -1 if the first argument is smaller than the second according to the current sort order, and 1 otherwise.
Syntax :
STRCMP(expr1,expr2)
Example :
SELECT STRCMP(’wordlist’,'WORD LIST’);
