advanced myslq query

[eluser]tonanbarbarian[/eluser]
it might take "big data" but that is what a database is designed to do, process lots of data quickly and efficiently.

i garentee that if you desgin the database correctly and use a separate table as suggested you would see a major speed improvement once you have a real dataset to work with.
the regexp might seem ok when you run it with only a few records in the table, but once you have thousands of records the separate table with the colour selections will be vastly quicker

and it will be easier to change to doing it now than it will at some later date when you have thousands of records in the table