mysql select all except one column code example

Example 1: mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Example 2: list in one column mysql

country table
-------------
id
name
other_column


rule table
----------
id
name
other_column


countryrules table
------------------
country_id
rule_id