Simple MySql conditional SELECT Query Problem with BOOLEAN

Question

I've got a pretty simple issue here which I can't get to work.

SELECT * FROM pto_products WHERE blacklist IS NULL AND pzn LIKE '%$term%' OR name LIKE '%$term%'

Columns: blacklist is a MySql BOOL Field, TINYINT If the Record is blacklisted the value is set to 1 otherwise NULL

pzn is the Index and

INT name VARCHAR(255)

The Issue I have is that I allways receive all records including the blacklisted ones when I run this query. Does anyone know how I maybe need to group the conditions to achieve the needed result so the blacklisted records are excluded?

Thanks in advance!

Dark Falcon · Accepted Answer · 2011-08-12 10:34:45Z

4

SELECT * FROM pto_products WHERE blacklist IS NULL AND (pzn LIKE '%$term%' OR name LIKE '%$term%')

answered Aug 12, 2011 at 10:34

Dark Falcon

44.2k6 gold badges91 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Simple MySql conditional SELECT Query Problem with BOOLEAN

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related