MySQL Forums
Forum List  »  Knowledge Base

Query(need help)
Posted by: Naved Pasha
Date: May 22, 2009 12:57AM

Hi iam a new user of the MySql and i have one problem..

The problem is that i want to select all the fields from table by

comparing name="value" city="value" state="value" country="value" and

zip="value".but i dont know how to join all of them in one query.and its not

compulsory that all the fields value will be provided,some of them will be

provided some of them not.
like: select * from table where name="name" and state= state;//remaining is unavailable

Is there anyone who can help me to sort out the problem.
Thanks & Regards
Naved Pasha

Options: ReplyQuote

Written By
Query(need help)
May 22, 2009 12:57AM
June 19, 2009 09:58AM
July 27, 2009 07:37AM
August 15, 2009 11:36AM

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.