The task is as follows: you need to select non-indexed table fields, for example:
SHOW COLUMNS FROM table WHERE key <> 'PRI'
But mysql swears on key
. I understand this is a reserved word and you can’t use it as it is. How can I get around this situation?
Thank.