Ok how can i mix boolean and regexp searches?
SELECT * FROM tbl WHERE MATCH (name) AGAINST ('TEST' IN BOOLEAN MODE) OR name
REGEXP 'TEST';
That dont work :(
Quoting [EMAIL PROTECTED]:
> 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
-------------------------------------------------
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
