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
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.