how to select multiple names in a single query

Question

I have a sql query which is like that

 select * 
 from users 
 where uname="ali" and uname="veli"

but it is not worked what ı want to do is get the person whose name is "ali" and "veli" but if "ali" is not exist and "veli" is exist, the existed ones should be return. How can I do this. it is easy query but I am confusing.

Answer 1

Try this:

 SELECT * 
 FROM users 
 WHERE uname IN ("ali", "veli")