CODEWITHSUNDEEP
mysql
Muhammad Kazim
Muhammad Kazim

Reputation: 621

how to get specific columns name from MYSQL

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

Upvotes: 0

Views: 314

Answers (1)

Thamilhan
Thamilhan

Reputation: 13323

Use WHERE to filter FIELD column

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

Upvotes: 1

Related Questions