The syntax for the "IN" condition is:
[code=text]expression in (value1, value2, .... value_n);[/code]
SQL "IN" Condition - Character example
[code=text]SELECT *
FROM suppliers
WHERE supplier_name in ('IBM', 'Hewlett Packard', 'Microsoft');[/code]
[url]http://www.techonthenet.com/sql/in.php[/url]
No comments:
Post a Comment