validus wrote:
> Yes. Of course the real application isn't searching for colors. That
> was just a quick example.
> Sorry for the confusion. Basically I'm trying to find the easiest
> and/ or the most efficent method
> to show rows with ALL 3 terms in any given order without a full text
> search if possible.
> Of course that may be the only decent method to implement this. I
> wasn't sure if there
> was any regexp mojo that could be done to implement this.
>
> validus
>
>
>> Are you suggesting that a desc field could contain all 3 colours in
>> a single record?- Hide quoted text -
>>
>> - Show quoted text -

Rows with 3 terms where? If you have 3 different "terms" in a single field,
then your database isn't even in 1NF. Normalise it and the problem goes
away.