Select * when some column is entered?
-
As you all know, when you write a query like: select * from TableName where Column01 = 'value'; it retrieves the rows that are related to the column Column01. What I need is: I want to retrieve all the rows in the table when I pass some value in the Column01. I mean: retrieve all the table data when I say in the query : where Column01 = '100' The value '100' is unique for this purpose to retrieve all table data. Any ideas plz... :(
Kind Regards OBarahmeh
-
As you all know, when you write a query like: select * from TableName where Column01 = 'value'; it retrieves the rows that are related to the column Column01. What I need is: I want to retrieve all the rows in the table when I pass some value in the Column01. I mean: retrieve all the table data when I say in the query : where Column01 = '100' The value '100' is unique for this purpose to retrieve all table data. Any ideas plz... :(
Kind Regards OBarahmeh
-
As you all know, when you write a query like: select * from TableName where Column01 = 'value'; it retrieves the rows that are related to the column Column01. What I need is: I want to retrieve all the rows in the table when I pass some value in the Column01. I mean: retrieve all the table data when I say in the query : where Column01 = '100' The value '100' is unique for this purpose to retrieve all table data. Any ideas plz... :(
Kind Regards OBarahmeh
OR do you want to retrieve all rows when you give a 'where' condition also. :doh:
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE. How to post a question