How to list specific column name in the table

SELECT * FROM information_schema.columns WHERE table_catalog = 'myevo' AND table_name  = 'purchase_order' and column_name = 'batch_id'


sorted

SELECT * FROM information_schema.columns WHERE table_catalog = 'vbroker20-beta1' AND table_name  = 'vb_trade_tran' order by column_name