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
