scrap pad

1/21/2007

(4:14 PM)

sql where clause thing

for future reference:

SELECT * FROM Products WHERE ProductName IN ("Chair", "Table")
DELETE FROM TableName WHERE ID NOT IN (5, 6, 7)

(from "using sets with sql," a dumb article name for an article about "IN")

Archives

who I am