I'm wondering if there is a query to check all fields in a table without enumerating all the fields. My pseudo code would be something like:
SELECT * FROM table WHERE * > 5 except table.id;
Is there such query?
Asked
Active
Viewed 189 times
0
-
seems like `Select Top(5) where != id` – spajce Jan 28 '13 at 10:05
-
1possible duplicate of http://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql ? – user7282 Jan 28 '13 at 10:06
-
1Not. You have to enumerate all needed fields or use '*' to get all fields. Or generate SQL statement dynamic. – valex Jan 28 '13 at 10:06
-
When following the link provided by Zubin, make sure to read Jan Koritak's answer, not only the accepted one. – fancyPants Jan 28 '13 at 10:24