NOT query?

vaska

i want to exclude something from a query...but i'm not sure how to do this...i didn't find any answers at mysql.com

i just want to exclude and results that have the number "2" in the mainsecid column...this is the query...

$query = mysql_query ("SELECT * from main,sections,topics WHERE mainsecid=secid AND maintopid=topid ORDER BY id DESC LIMIT 0,15") or die ("Yo, it's not working! - Code1A.");

so need one more...that says something like...

mainsecid NOT EQUAL 2

can i do this...or do i have to do a workaround?

steved

$query = mysql_query ("SELECT * from main,sections,topics WHERE mainsecid=secid AND maintopid=topid ORDER BY id DESC LIMIT 0,15") or die ("Yo, it's not working! - Code1A.");

Just add in AND mainsecid <> 2
to your $query.

$query = mysql_query ("SELECT * from main,sections,topics WHERE mainsecid=secid AND maintopid=topid AND mainsecid <> 2 ORDER BY id DESC LIMIT 0,15") or die ("Yo, it's not working! - Code1A.");

sfullman

Hi, the last post was good but i don't think it answered everything. If you're looking that it not CONTAIN 2, then use like...

$query = mysql_query ("SELECT * from main,sections,topics WHERE mainsecid=secid AND maintopid=topid AND mainsecid not like '%2%' ORDER BY id DESC LIMIT 0,15") or die ("Yo, it's not working! - Code1A.");

if you want to exclude 2 in the first place use
not like '2%'

if in the middle use %2%, and if at the end use %2

for that matter you can use SUBSTRING() commands or REGEXP() commands. People underutilize mySQL commands, go see:

http://www.mysql.com/doc/en/Function_Index.html
Sam Fullman

[deleted]

ew!

sfullman, the question is clearly about records that may not have a value of 2 in one column that is even called 'somethingID', indicating that this is a number.

Substring is not an option for this, even if it was a string, en regexps in mysql are far too slow.