查询出以大写字母开头的单词列表

SELECT word
FROM edu_vocabulary
WHERE word REGEXP '^[A-Z]' and BINARY SUBSTRING(word, 1, 1) = UCASE(SUBSTRING(word, 1, 1));

 

posted on 2024-05-23 19:05  //君莫笑  阅读(2)  评论(0编辑  收藏  举报

导航