A Simple MySQL Query Question (I have Bad Syntax)
Im re-new to MySQL (haven't touched it in years) and am trying to display email addressed from a database table who's zip code begins with a "94". The Database is named 'mailinglist' and the table with the data is 'maillist'
So I think something like this would work; Code:
SELECT `PrimaryEmail` FROM 'maillist' WHERE `PrimaryZip` = '94%' |
Figured it out. And for archival purposes, here is my solution;
Code:
SELECT PrimaryEmail FROM maillist WHERE PrimaryZip LIKE '94%'; |
All times are GMT -5. The time now is 11:43 PM. |