Equal and not equal in PHP query

2 Views

I need to show a list of exhibits from a database. Some are events (shows lasting only one day), marked with a checkbox. I don’t want to include those.

When running my Query without and selector, I get 103 results.

Read More

If I add this line 

    AND `event`.`meta_value` = 'on'

I get 23 results (the events). It works well.

If I add that line instead 

    AND `event`.`meta_value` != 'on'

I get 12 results. They are not events, but it is missing 68 posts.

I also tried using <> instead of != with a similar result.

Post Views: 2

Related posts

1 comment

  1. They other 68 posts most likely have NULL as value, you should also be able to see this for yourself if you check the database. They won’t show up with = or != … If you want to see them you’ll have to change your query to specifically look for the attribute being NULL:

    AND `event`.`meta_value` IS NULL

Comments are closed.