Project / Support Center
Welcome, Guest. Please login or register. December 03, 2020, 12:28: PM
Home Help Search Login Register
D-Web Web Site Creator D - Web Web Site Creator On-line HTML Editor No Programming knowledge required. Web Global Net PayPal-Cart Shopping Cart System PayPal - Kart Shopping Cart System for E-Commerce over the internet, that's easy to use. Web Global Net Newsletter Manager Newsletter Manager On-line Newsletter Creator with Email Subscriber Management.
Ring Central Discount
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: Multiple Not = to elliminate from results 0 Members and 2 Guests are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: Multiple Not = to elliminate from results  (Read 1300 times)
admin
Administrator
******
Offline Offline

Posts: 209


« on: March 18, 2020, 01:48: PM »

I'm sure there are better ways to write the SQL but this works too.

Table fields enclosed in ` ` and the queries are enclosed in  " " Separate each not statement with an AND

SELECT *  FROM `events` WHERE `event_category_type` != 'Church'

AND `event_category_type` != 'Park'

AND `event_category_type` != 'Destination Location'

ORDER BY `event_category_type`  ASC


You can also eliminates this way

AND RIGHT(contact_email,11)!='noemail.com'
« Last Edit: May 22, 2020, 04:48: PM by admin » Report to moderator   Logged

The Unknown Webmaster
Pages: [1] Go Up Send this topic Print 
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: Multiple Not = to elliminate from results « previous next »
Jump to:  


Login with username, password and session length
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!