字符串對比函數 1、匹配字符 通配符%表示匹配0個或多個字符 通配符_表示匹配1個字符 ~~~ mysql> SELECT 'David!' LIKE 'David_'; -> 1 mysql> SELECT 'David!' LIKE '%D%v%'; -> 1 ~~~ 當匹配字符中有特殊字符時，可以用 \或者escape來指定特殊字符為字符 ~~~ mysql> SELECT 'David!' LIKE 'David\_'; -> 0 mysql> SELECT 'David_' LIKE 'David\_'; -> 1 mysql> SELECT 'David_' LIKE 'David|_' ESCAPE '|'; -> 1 ~~~ 2、expr NOT LIKE pat [ESCAPE 'escape_char'] 是上一個字符串對比函數的反義 3、STRCMP(expr1,expr2) 當expr1等于expr2時等于0，當expr1小于expr2時為-1，反之為1 ~~~ mysql> SELECT STRCMP('text', 'text2'); -> -1 mysql> SELECT STRCMP('text2', 'text'); -> 1 mysql> SELECT STRCMP('text', 'text'); -> 0 mysql> SET @s1 = _latin1 'x' COLLATE latin1_general_ci; mysql> SET @s2 = _latin1 'X' COLLATE latin1_general_ci; mysql> SET @s3 = _latin1 'x' COLLATE latin1_general_cs; mysql> SET @s4 = _latin1 'X' COLLATE latin1_general_cs; mysql> SELECT STRCMP(@s1, @s2), STRCMP(@s3, @s4); +------------------+------------------+ | STRCMP(@s1, @s2) | STRCMP(@s3, @s4) | +------------------+------------------+ | 0 | 1 | +------------------+------------------+ ~~~