I want to display all columns in a record except one of them. For example in my table I have
'name'
'address'
'phone number'
'notes'
Of course to show all the fields in a search I would use 'SELECT * FROM table'.
If I want to leave out the 'notes' field I could do 'SELECT name, address, phone number FROM table'.
Is there a way to avoid listing all the fields (say I had a large # of them) and just mention the one I wish to omit?
