WHERE - Stuck

[RidgeandGable]

SELECT Name, Town, Category
FROM customer1
WHERE Name = colname 

Code is above (Dreamweaver CS6)

 

​I need Where Name & Town to filter on? Any help?

[NotionCommotion]

???

SELECT Name, Town, Category
FROM customer1
WHERE Name = "Bob" AND Town="San Francisco";

[mikesta707]

Not sure exactly what your asking. If its for a sql query to search based on name and town it would be like

 

 

SELECT Name, Town, Category FROM customer1 WHERE Name="something" OR Town="something"

 

where something is your search term.