[Resolved] SQL query mystery

[lazzerous]

I have a SQL query that pulls information from a table called 'jobs_posted'

At the end of the query, I reference to a field called 'status'

I'm looking to only pul entries that have 'status' marked as 'active'

in the table, status is marked as enum('active','inactive')

Here's the problem - the full query pulls all entries with 'status' markes as both inactive and active, even though the query specifies that only active should be pulled.

The query broken down to a simple statment works just fine, but I can't figure out why...

Any help would be appreciated, as I am obviously not seeing the problem with my SQL statment here...

Full Query:
select distinct id, job_title, job_desc from jobs_posted where (job_title like '%test%' and job_title like '%entry%' and job_title like '%data%' ) or (job_desc like '%test%' and job_desc like '%entry%' and job_desc like '%data%' ) and status = 'active' order by job_title

Simple Query:
select distinct id, job_title, job_desc from jobs_posted where status = 'active' order by job_title

-=Lazz=-

[broc7]

Put additional parentheses around your 'or' options.

...where ((sql) or (sql)) and (sql) order by...

Without them, the db is operating as if the parentheses were positioned like:

...where (sql) or ((sql) and (sql)) order by...

so that your first sql can return results on its own.

Also make sure that you're not using %active% because that will return both actives and inactives.

[lazzerous]

HA!

I'm an idiot

I always miss the little things

Thanks man - I can't believe I missed that.