Thanks, but this won't work, we need an exact match of one of the multiple
values, if there is one exact match of any of the values within the column, then
we pull that row out to be displayed. so it has to be an exact match.
>>On Tue, 10 Jul 2001 23:05:02 -0500, "Rodrigo Zerlotti" <[EMAIL PROTECTED]> wrote:
>>
>>
>>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
>>>
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
