RE: can someone explain this query to me

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



WHERE id IN (1,2,3)

Is the same as saying WHERE id = 1 OR id = 2 OR id = 3

Few more details in this link

http://www.w3schools.com/sql/sql_in.asp

HTH

Dan

-----Original Message-----
From: Ross [mailto:ross@xxxxxxxxxxxxx] 
Sent: 20 December 2005 12:07
To: php-general@xxxxxxxxxxxxx
Subject:  can someone explain this query to me

$query = "delete from meetings where id IN (".implode(",", $ids).")";


Just the end bit, ids is an array of values (1,2,3,4,5) what does the IN 
do??

Ross 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

__________ NOD32 1.1328 (20051219) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux