I have a text field in some table. I would like to perform a SELECT with search. The requirement is to match all words in $text string, doesn't matter about case or the other of the words, but all the words must be in the text field. How could I do this? I'm using MySQL 3.23 and only 4.00+ have binary search with MATCH...AGAINST. Version 4.00+ is still not stable versions, so I would not upgrade. Please help. Thanks.
