Question

我只想从UPPER N开始选择名字,没有低等。

我尝试:

SELECT * FROM states WHERE name LIKE  N%  ORDER BY id ASC;

SELECT * FROM states WHERE name RLIKE  ^N  ORDER BY id ASC;

I also tried similar to and regex but the results are always upper and lower N names; what to do?

Answer 1

请注意,您仅可定期使用<代码>。 LiKE载于本文而不是RLIKE/REGEXP,作为LIKE,可在一封信中发出。使用<条码>LIKE,<条码>。 3. 使比较情况敏感的关键词:

SELECT *
FROM states
WHERE name LIKE BINARY  N% 
ORDER BY id;