RE: [PHP] is there a more efficient query?
| From: | Jay Blanchard | Date: | Fri, 06 Aug 2004 16:28:13 +0000 |
| Subject: | RE: [PHP] is there a more efficient query? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193011@lists.php.net to get a copy of this message | ||
[snip]
Tis SQL ....
SELECT value
FROM element_values
WHERE user = $user_id
AND(element=48
OR element=52
OR and so on....)
[/snip]
You can also use IN
SELECT value
FROM element_values
WHERE user = $user_id
AND element IN ('48', '52',...)