MySQL:不喜欢 [英] MySQL: NOT LIKE

问题描述

我的数据库中有这些文本，

I have these text in my db,

categories_posts
categories_news
posts_add
news_add

我不想用categories选择行，我使用类似这样的查询，

And I don't want to select the rows with categories, I use a query something like this,

SELECT *
    FROM developer_configurations_cms

    WHERE developer_configurations_cms.cat_id = '1'
    AND developer_configurations_cms.cfg_variables LIKE '%parent_id=2%'
    AND developer_configurations_cms.cfg_name_unique NOT LIKE '%categories%'

但是它也会在输出中返回这两个...

but it returns these two in the output as well...

categories_posts
categories_news

如何在查询中忽略它们?

How can I ignore them in my query?

谢谢.

推荐答案

categories_posts和categories_news以子字符串'categories_'开头，则足以检查developer_configurations_cms.cfg_name_unique以'categories'开头，而不是检查它是否包含给定的子字符串.将所有内容转换为查询:

categories_posts and categories_news start with substring 'categories_' then it is enough to check that developer_configurations_cms.cfg_name_unique starts with 'categories' instead of check if it contains the given substring. Translating all that into a query:

SELECT *
    FROM developer_configurations_cms

    WHERE developer_configurations_cms.cat_id = '1'
    AND developer_configurations_cms.cfg_variables LIKE '%parent_id=2%'
    AND developer_configurations_cms.cfg_name_unique NOT LIKE 'categories%'

这篇关于MySQL:不喜欢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！