Select column comment
Selects
is_optional
column comment which exists in
decorations
table using
information_schema
database
SELECT COLUMN_COMMENT 
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'geiger' 
    AND TABLE_NAME = 'decorations' 
    AND COLUMN_NAME = 'is_optional'
by Valeri Tandilashvili
4 years ago
MySQL
Column comment
1
Pro tip: use ```triple backticks around text``` to write in code fences