Posted by Peter Fox on 05/27/05 11:38

Following on from 's message. . .
>I know that MySQL has a "set" data type, but I have no idea whether
>it would apply to this problem, or how to use it.

Use Text and Full Text Search. This does all you want and probably with
a great deal less constraints than what you are thinking of. Using a
SET field definitely sounds like the wrong thing unless there are only a
few dozen fixed key words. The manual explains it all.


--
PETER FOX Not the same since the bridge building business collapsed
peterfox@eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

[Back to original message]