The difference between SHOW and SELECT query ?

Answer 1

it is easier to chance the characteristics with SELECT

Answer 2

SHOW is a older term, so SELECT is better

Answer 3

SHOW will display all the databases and tables, while, with SELECT it will display particular tables and columns.