显示表中的所有列值

Question

I want to show the all values from table. I know i can do that with

SELECT COLUMN_NAMES FROM TABLE_NAME WHERE COLUMN='VALUE'

But it is showing just wanted values i want all columns with the SHOW COLUMN query.

I have try it like this:

SHOW COLUMNS FROM lang 

then it gives me all details from the lang table. So if i want to show lang table id = '5' like the following query

SHOW COLUMNS FROM lang WHERE id='5'

then i am geting Unknown column 'id' in 'where clause'

Please look at the following shema it is like my table.

I want to show for example id=5 all information like id, key, english, turkish ect. Why i wanted this because if i add more then language like russian, germany ect. then i need to get also that language information in the result.

+------+----------------+---------------------+---------------------+
|  id  |      key       |     english         |   turkish           |
+------+----------------+---------------------+---------------------+
|  1   |       hi       |       Hi            |    Merhaba          |
+------+----------------+---------------------+---------------------+
|  2   |     profile    |      Profile        |    Profil           |
+------+----------------+---------------------+---------------------+ 
|  3   |      menu      |       Menu          |     Menü            |
+------+----------------+---------------------+---------------------+
|  4   |    forgot_pass |  Forgot Password    |  Şifremi Unuttum!   |
+------+----------------+---------------------+---------------------+
|  5   |    wellcome    |      Wellcome       |   Hoş geldiniz!     |
+------+----------------+---------------------+---------------------+

Answer 1

Use SELECT * instead:

SELECT * FROM lang where id = '5'