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.

    1 answer 1

    And if so:

     SHOW COLUMNS FROM `table` WHERE `key` <> 'PRI' 
    • Thank you! So it worked :) - proteamer