On 4/13/06, Jakob Voss jakob.voss@nichtich.de wrote: [snip]
How about about a title search?
SELECT page_id FROM page WHERE page_title RLIKE $regxp AND $conditions LIMIT $limit
It would be useful to find articles named "FOO (BAR)", "List of FOO" etc.
narf.
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.