Question

mysql数据库如何查询出某字符串字段不以指定后缀为结尾的记录？

比如我有一个表table 有一个字段url 字符串类型
我要查询出table表中url字段的结尾不是"js","css","jpg"的所有记录 怎么查？

Answer 1

select * from table where id not in (select id from table where url like '%js' and url like '%css' and url like '%jpg')