Re: where match question
| From: | chris smith | Date: | Tue, 23 Jan 2007 08:46:33 +0000 |
| Subject: | Re: where match question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-247619@lists.php.net to get a copy of this message | ||
On 1/23/07, Németh Zoltán <znemeth@alterationx.hu> wrote:
On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote: Don wrote:And how are you going to index that? That's going to be extremely slow as the size of the table grows. -- Postgresql & php tutorials http://www.designmagick.com/I have a db field that contains zip codes separated by comas. I am trying to get php to return all of the rows that contain a particular zip code. $query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip')";try this $query = "SELECT * FROM info WHERE column LIKE '{$zip}'"; I would use $query = "SELECT * FROM info WHERE LOCATE('{$zip}', column) > 0";