From: "Paul Groves" > BTW is there anyway to speed up the search, as I think this may be > pretty slow (there will be about 25000 records in the real database...) > e.g. maybe by doing a LIKE match for "%elbow%" first then doing a REGEXP > within that? Not sure how one would code the SQL for that, though...
LIKE '%... ' will be pretty slow too, since it can't use an index, just like REGEXP can't. Take a look at http://dev.mysql.com/doc/mysql/en/fulltext-search.html , maybe this is what you need. Do read all the articles in section 12.6 to make sure you know the pros and cons... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]