MySQL: NOT LIKE

Question

I am having these texts in my database,

categories_posts
categories_news
posts_add
news_add

And I don't need to select the rows with categories, I use the 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%'

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

categories_posts
categories_news

How can I ignore them in my query?

Answer 1

"categories_posts" and  "categories_news" begin with the substring "categories_" and then it is adequate to check that "developer_configurations_cms.cfg_name_unique" begins with "categories" rather than check if it has the given substring. Translating all that into the 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%'

 Looking for a SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.