Mike Mike - 1 year ago 63
SQL Question

Script - Have I formatted multiple values correctly?

If I use the following script, it deletes a information from our database.

I have a few hundred users to delete. I wanted to include them in one script and delete them all. The thing I can't remember is if I can comma delineate them to include them in a single query or not

So if I have the following 3 users, would the script below work correctly to delete all 3 of them?

Answer Source

Use the in clause:

delete from FILE_Users where USER_ID in ('USER/Jo.Ann', 'USER/Mike.Jordan', 'USER/Jim.Buss')