Have a list of data that you want to look up in a single SQL command? Here's a syntax you can try.
We'll be using the "IN" command
Data needs to be comma delimited and encapsulated in parentheses
Select * from TABLE_NAME
where COLUMN_NAME in ('DATA1', 'DATA2', 'DATA3', 'DATA4')
example
Select * from CustomerData
where UserName in ('JBsmith', 'RDAndrews', 'BIJones', 'KARing')
If this tutorial has been of any help to you, I'd love to know!
If you have suggestions of how to improve it, let me know in the comments! Thanks!
No comments:
Post a Comment
Feel free to leave a comment! If you have any information that you think should be included, please do so here and I'll get it added in.