我只想 Select 以高N开头的名称,不包括低N.
我试过:
SELECT * FROM states WHERE name LIKE 'N%' ORDER BY id ASC;
SELECT * FROM states WHERE name RLIKE '^N' ORDER BY id ASC;
我还try 了类似于和regex 但结果总是大写和小写的N个名字; 该怎么办呢?
我只想 Select 以高N开头的名称,不包括低N.
我试过:
SELECT * FROM states WHERE name LIKE 'N%' ORDER BY id ASC;
SELECT * FROM states WHERE name RLIKE '^N' ORDER BY id ASC;
我还try 了类似于和regex 但结果总是大写和小写的N个名字; 该怎么办呢?
请注意,在这里您可以只使用常规的LIKE
,而不是RLIKE/REGEXP
,因为LIKE
可以以字母开头.将LIKE
与关键字BINARY
配合使用可使比较区分大小写:
SELECT *
FROM states
WHERE name LIKE BINARY 'N%'
ORDER BY id;