selecting rows

[ryanschefke]

Hello,

What is the best query to use optimized for speed that will search a table for rows where the column value is contained in a block of text that is stored in another table?

For example, if I am storing "Blue, Yellow, Purple, Green" in one large text value in the "color" column of table "Crayons", how do I SELECT the rows in the "Todays_crayons" table if the value in the "color" column matches any of the values in the "color" column (the text block) of the "Crayons" table?

Thanks,
Ryan

[laserlight]

In the first place, avoid multi-valued columns, so do not have that one large text field. Then you can do a join with normal matching instead of a slow substring search.