How can I search a Table row for a certain value?
$qry = $connection->prepare("SELECT (row) FROM UserData WHERE * = ''");
I tried this but it didn't work. After I do this can I find which col it was?
Asked
Active
Viewed 321 times
0
-
What exactly are you trying to do? – Oke Tega Aug 06 '17 at 22:31
-
I want to search a row from left to right and check if the value is empty and know which column it was. – Ron Arel Aug 06 '17 at 22:33
-
`SELECT (row) FROM table WHERE tablecolumn = ''` – Oke Tega Aug 06 '17 at 22:36
-
How is this a duplicate of the question given when there isn't even a clear explanation of what this question is? – Altimus Prime Aug 06 '17 at 22:41
-
You cannot use a wildcard in the column name: you need to tell MySQL which columns to look into. – Terry Aug 06 '17 at 22:45
-
What if I have a lot of column and I want to check all of them from left to right. tablecol1,talblecol2, etc. – Ron Arel Aug 06 '17 at 22:47
-
do I have to do one by one? also how can I check if it is true and which col it was. – Ron Arel Aug 06 '17 at 22:49