Does the FIND_IN_SET() function mentioned in the manual have any performance bonuses over doing a LIKE search for a SET fields? I'm trying to decide between using a SET or a separate lookup table at the moment, but data needs to be searchable and could have a lot of values, so it needs to be scalable.
The FIND_IN_SET() function is mentioned on the page about the SET field type, but doesn't seem to have a proper manual entry itself. -- Tim Fountain | Web developer | Incutio Limited | www.incutio.com email: [EMAIL PROTECTED] | Tel: +44 8708 700 333 | Fax: +44 7092 181 581 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]