By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,306 Members | 1,657 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,306 IT Pros & Developers. It's quick & easy.

How to get column names with where condition included?

P: 23
I have a table "services_detail".

id order_id URL keywords22 Description Keyword53
1 4468 --- ---- --- df
2 3571 U1 pqrs dfgdfg
3 9163 --- wxyz ---

Then how to get column names based on following value
1)pqrs (I want - Keyword22(As query Answer)) - Query?
Feb 4 '11 #1
Share this Question
Share on Google+
2 Replies

code green
Expert 100+
P: 1,726
You are thinking in reverse.
The only way you can possibly return 'pqrs' is by naming the column in the query
Feb 4 '11 #2

P: 23
Thanks very much for the suggetion.
Feb 5 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.