Difference between "SELECT" and "SHOW" in SQL

Question

What is the difference between
"SELECT phone no. FROM friends"
And
"SHOW phone no. FROM friends"

Answer 1

SHOW does not work like SELECT, it does not retrieve the data values. If you specify COLUMNS above, you will receive column information, instead -- columns' names, types, keys and properties.
As far as I know, you can't specify a particular column name in a SHOW statement.

Take a look at possible SHOW uses:
https://dev.mysql.com/doc/refman/8.0/en/show.html

Answer 2

Got it 👍