[Dispair2]

I wanted to see if anyone can help me in building an sql statement for searching items such as weapons, armor, bags, so on. All i really need to know is what the where clause would be like select * from items where ???? i can not find any column in the items table that determines what these items are.