On 4/13/06, Jakob Voss <jakob.voss(a)nichtich.de> wrote:
How about about a title search?
SELECT page_id FROM page WHERE page_title RLIKE $regxp AND $conditions
It would be useful to find articles named "FOO (BAR)", "List of FOO"
Seqscanning through a million rows on each users query?
I think not.
It MySQL's full text indexing worked on anything but myisam tables it
would be easy to provide your title search, but they don't.