select ID from TABLE_NAME where ID like '%value%'
or I misunderstood the question.....
---------
Regards,
Rod~
> -----Original Message-----
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of Mike<mickalo>Blezien
> Sent: Tuesday, July 10, 2001 10:38 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple column value
>
>
> Hi All,
>
> Quick question. We need to store a multiple value in a table
> column as we don't
> know how many values at the time of submission there could be.
> The column would
> be storing a group of values something like this:
>
> Column 'ID'
> IM34456,IM34485,IM34478
>
> or it could be more or less. So if we put the data into one
> column what would be
> the best way to extract the row if there's is a match of one of
> the values in
> the column.
>
> We need to build a query to select a row that matches one of the
> values. They
> would enter a single value like IM34485 into a form, then I need
> to build a
> query that will check all values in the ID column so we can then
> extract the
> entire row if one of the ID values match.
>
> THX,
>
> Mike(mickalo)Blezien
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225)686-2002
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php