[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

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 table with millions of records. I've full

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