Re: [PHP] Mysql search query ignoring dots

2011-01-24 Thread Tom Rogers
Hi, Monday, January 24, 2011, 10:50:41 PM, you wrote: BP> Hi all, BP> I have to perform a mysql query in a table with millions of records. BP> I've full-text indexed my search field and I'm searching with MATCH AGAINST. BP> But there is a problem. In this field there are company names that BP> c

RE: [PHP] Mysql search query ignoring dots

2011-01-24 Thread Tommy Pham
> -Original Message- > From: Barbara Picci [mailto:barbara.pi...@sardi.it] > Sent: Monday, January 24, 2011 4:51 AM > To: php-general@lists.php.net > Subject: [PHP] Mysql search query ignoring dots > > Hi all, > > I have to perform a mysql query in a tab

[PHP] Mysql search query ignoring dots

2011-01-24 Thread Barbara Picci
Hi all, I have to perform a mysql query in a table with millions of records. I've full-text indexed my search field and I'm searching with MATCH AGAINST. But there is a problem. In this field there are company names that contain dots, for istance I've "PO.SE. srl" and I want to find it if the u