I don't see another way other than like since you build the value on a
"free" form, i.e. you determined the separator ",". You can either get a
dif. form to help on your selection or just do a:
select ID from TABLE_NAME where ID = $value || ID like '$value,%' || ID
like '%,$value,%' || ID like '%,$value'
---------
Regards,
Rod~
> -----Original Message-----
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of Mike<mickalo>Blezien
> Sent: Tuesday, July 10, 2001 10:50 PM
> To: Rodrigo Zerlotti
> Cc: [EMAIL PROTECTED]
> Subject: Re: Multiple column value
>
>
> 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
