[RESOLVED] SELECT with number string

[jme]

Hiya guys.

I am wanting to do a select on a database which store items for a webstore. Within this table there is a item_category section.

For example I have 50 categories, and I want all to be displayed execpt those in categories 13, 37 and 38. Basically like:

eg something like SELECT * from items where item_category doesn't = 13, 37, 38

Many thanks.

Jamie 🙂

[Lars_Berg]

SELECT * from items where item_category not in (13, 37, 38)

[jme]

Excellent. Worked perfectly.

Many thanks 😃