这是来自的mysqlselect distinct city from station where city not regexp '^[aeiou]' and city notregexp '[aeiou]$'select distinct city from station where city not regexp '^[aeiouAEIOU*[aeiouAEIOU]
在我的数据库表中,我有一个字段"description“,它是一个文本字段。它包含像这样的值:
This bracelet is composed of round diamond surrounded by milgrain detailing.我想查询包含确切单词“菱形”的列。当我以select description from tproduct where description like '%diamond%'形式查询时,它会给出结果,但它会