Re: where match question

On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote: > Don wrote: > > 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"; greets Zoltán Németh > > > > > $result = mysql_query($query) > > > > or die ("could not connect to db"); > > > > $row = mysql_fetch_row($result); > > > > > > > > > > > > this works if there is only one row that contains that zip code. > > > > > > > > If there is more than one row that contains the zip, it returns 0 rows. > > ('It' being MYSQL that returns 0 rows. I checked this by running the query > > directly to the DB) > > > > > > > > Any ideas are very much appreciated. > > > > > > > > Thanks, > > > > > > > > Don > > > > > > > > > > > > >