[thelist] MySQL "OR"

[Hans Zaunere]

Andrew Kamm wrote on Thursday, September 08, 2005 8:51 AM:
> Is it proper to execute a rather long SQL query in MySQL?  I'm not aware
> of a reason this wouldn't work (unless there is simply a limit on the
> length of a queries), but I'm not sure if it's bad form or if the DB
> would respond poorly.
> 
> Please see the PHP code below.  At this point in the code, I've gathered
> an array of advertiser_id's from a separate function, and I want to do a
> query that basically says "SELECT X FROM TABLE Y WHERE advertiser_id =
> $q_or" where $q_or is the imploded array below.  As the app grows, this
> could become a potentially long list of "OR's".
> 
> if (is_array($advertisers))
>         {    //Wrap array values with ' '
>             foreach($advertisers as $value)
>             {
>                 $newAdvertisers[] = "'".$value."'";
>             }
> 
>             //Create 'or' section of query with array
>             $q_or = implode(" OR advertiser_id = ", $newAdvertisers);
> 
>             //SELECT STATEMENT, ETC....
>         }
> 
> Thanks in advance!

You don't want to over use the logical OR.  Also consider IN()

http://dev.mysql.com/doc/mysql/en/comparison-operators.html



---
Hans Zaunere / President / New York PHP / www.nyphp.com