MySQL Forums
Forum List  »  Quality Assurance

Re: using IN, but the value must be in all of them
Posted by: techforums123 ds
Date: May 24, 2011 12:19AM

YOU need to provide in clause for the column,

ex : select * from table1 where name = 'mauricio' AND type IN ('STAFF','MANAGER','CLIENT')

here it search for name and type column if true , then it result the answer, if false then it doesnt

to display all I think you need to use Join Statement

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: using IN, but the value must be in all of them
809
May 24, 2011 12:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.