On Fri, Jun 27, 2003 at 05:27:02PM -0500, Michael Brunson wrote: > On Fri, 27 Jun 2003 14:50:58 -0700, "Dathan Vance > Pattishall" <[EMAIL PROTECTED]> wrote: > > | So, my question is how can multiple values for a single field get > | represented in a single row and receive the benefits of an index? How > | can this data be represented? > > Try using a SET column type and then using mysql's > FIND_IN_SET() function in your where clause.
Excepet that he wants to "receive the benefits of an index" in this case. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 24 days, processed 778,166,849 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
