Linking Database Tables With CSV?

[ShoeLace1291]

I have two tables.  Let's call the first one items and the second one item categories.  Now the items table would look something like this:

 

id(auto_increment id)

name

description

categoryid

 

The item categories table would look something like this:

categoryid

name

description

 

An entry in the items table would look something like this:

categoryid = 1,2

name = Thing

description = something

id = 1

 

Say I want to retrieve records that contain "1" in the categoryid column.  How would I do that?

[jcbones]

This should work:

 

 

SELECT * FROM table WHERE 1 IN(`categoryid`);