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, turkishect. 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! |
+------+----------------+---------------------+---------------------+
Use SELECT * instead:
SELECT * FROM lang where id = '5'