Query - SELECT - WHERE

    Date: 12/19/05 (MySQL Communtiy)    Keywords: php

    I need to write a query that looks for records that contain matching cities and zip codes to list.

    Is there a way to search a string or array for a value like we can with PHP?


    ***
    I dont want to match city and zip, I want to match city or zip.

    So I would x items to look through the records.

    Some kind of WHERE syntax that looks something like this: ...zip1 OR city1 OR zip1 OR city2...


    Thanks!

    Source: http://www.livejournal.com/community/mysql/78395.html

« merging many fields || Fulltext index error »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home