can i use != instead of 'NOT IN' eg. SELECT*FROM table_name WHERE city != ('La', 'ny', 'lag');

Question

SQL logical statement

Answer 1

No, because != will do an exact comparison of the value in the city field. Most likely, this syntax won't be valid (currently not at a computer), but even if it was, it would return everything that didn't have a city called ('La','ny','lag'), so every row would be returned, which isn't what you'd expect.

Answer 2

no. because not in is a group function but != is for single value. So you cant use when you need array kind of value