John thegimper <[EMAIL PROTECTED]> wrote on 08/22/2005 04:55:46 AM: > my host dont want to change the ft_min_word_len it´s now at 4 chars > and i need > to do searches with only 2 chars. > > Quoting Jasper Bryant-Greene <[EMAIL PROTECTED]>: > > > John thegimper wrote: > > > Thanks so there is no operator that tells mysql that both words must > > match? > > > > > > "one|two" is equal to "one OR two" > > > I want an operator that is equal to "one AND two" but i guess i will > > have to > > > use match in boolean mode for that? > > > > Why not use full-text searching instead of regexp? > > > > Jasper > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > There is nothing stopping you from combining FT searches with REGEXP searches. Put the terms with 4+ characters into the FT condition and the rest can be munged into some flavor of REGEXP condition. An alternative is to build a list of PKs for the records that have *any* term you need in it then hitting that list looking for how many terms matched. There are SO many ways to approach this kind of search but you are definitely on the right track by building and using FT indexes along with the REGEXP.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
