mysql> select unit, name1, email from dbname; +------+--------------------+---------------------+ | unit | name1 | email | +------+--------------------+---------------------+ | 001 | duckman industries | poorjohn@google.com | +------+--------------------+---------------------+ 1 row in set (0.00 sec)