how to get specific columns name from MYSQL

Question

in MYSQL how to get specific columns name for example: i have following cols in databse

ID
NAME
ADDRESS
MOBILE

below query shows all the above columns name but i want to get all cols except ID and MOBILE.

SHOW COLUMNS FROM CONSIGNEE

Are you talking about select statement? use can use like this "select ID from tbname". Its pretty simple. — Davinder Kumar
– Davinder Kumar, Commented May 3, 2017 at 6:39
If you want to get list of columns for a given table you can query information_schema.columns table — user1881277
– user1881277, Commented May 3, 2017 at 6:40

Thamilhan · Accepted Answer · 2017-05-03 06:41:16Z

1

Use WHERE to filter FIELD column

SHOW COLUMNS FROM CONSIGNEE WHERE FIELD NOT IN ('ID', 'MOBILE')

answered May 3, 2017 at 6:41

Thamilhan

13.3k5 gold badges40 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1