Select match from a stored delimitated string?

[Verdon vaillancourt]

Hi :)

I'm not even sure if I'm naming the question correctly. I hope I can
ask/explain it clearly enough to get a hint ;)

Essentially...

1) I have a table of portfolio 'pieces', each row of which has a unique ID

2) I have a table of 'projects', which are comprised of a number of
'pieces'. There is a column in this projects table called 'pieces', which
contains a delimitated string of all the 'pieces' related to that 'project',
in the format of '1||2||3||5||12||16||17||24||25'

3) When viewing a data sheet of a single row in the table 'pieces', I'd like
to be able to include a reference to any 'projects' that the said piece may
be a member of.

I've tried a few things like

$ID = '1';

SELECT * from projects WHERE pieces LIKE '$ID%'
- which will find anything that starts with $ID, such as
1||3||4

SELECT * from projects WHERE pieces LIKE '%$ID%'
- which will find anything that contains $ID, such as
1||3||4
5||1||72||8
3||5||21||9
3||5||17||9

What I can't figure out how to do is to select this
3||5||1||9

Without selecting something like
3||5||21||9 or
3||5||17||9

Is this possible in a single sql statement, or do I have to select all rows
of 'projects' and use php to somehow loop through the results, explode the
delimitated strings, and look for the exact match this way, somehow.

If you haven't noticed, I'm a little bit of a newbie, so please be nice :)

Salut,
verdon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw