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


Subject
Views
Written By
Posted
Query(need help)
2763
May 22, 2009 12:57AM
1708
June 19, 2009 09:58AM
1640
July 27, 2009 07:37AM
1473
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.