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...
The main con for me is that it won't index words of three characters (which I think I will in my queries) or less unless I change the default server setting (can you do this on a by database basis?), which may be possible, but it depends where its finally hosted...
regards
Paul
-- ------------------------------------------------------------------------- 'It is attitudes not policies that are stifling innovation in educational uses of technology!' Do you agree?
To discuss this, book now for **two major e-learning conferences** at Oxford University:
'Shock of the Old 5: Implementing Innovation' 7th April 2005 'Beyond the Red Tape' 8th April 2005
Details at: http://www.oucs.ox.ac.uk/ltg/events/ -------------------------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
