Searching Within A Field

[hansman]

Hello, If i have a field that has a bunch of city names, how can i start a search to see if the city is in that field or not?

The cities are separated by commas

[revraz]

use LIKE

[hansman]

Here is my code

 

SELECT Companies.Name, Companies.Address, Companies.Website, Companies.Email, Companies.Services, Companies.Fax, Companies.Phone, Companies.ZipCodes, Zips.ZipCode, Zips.StateAbbr FROM Companies, Zips WHERE Companies.ZipCodes LIKE \%'$zip'%\ 

 

i get the error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\%'10511'%\' at line 1

[revraz]

 

 

LIKE '%$zip%'

[fenway]

Um, you're missing a JOIN condition!

[bluejay002]

summed up:

 

SELECT Companies.Name, 
Companies.Address, 
Companies.Website, 
Companies.Email, 
Companies.Services, 
Companies.Fax, 
Companies.Phone, 
Companies.ZipCodes, 
Zips.ZipCode, 
Zips.StateAbbr 
FROM Companies
LEFT JOIN Zips ON <place_your_condition_for_joining_here>
WHERE Companies.ZipCodes LIKE '%$zip%'

 

The condition that fenway wants to point out is to avoid unnecessary pairing of records from one table to another.

[fenway]

And it had better be a INNER JOIN if you're going to use a where clause from the 2nd table!