I have a MYSQL database table with a field that contains information like below...
ID: 1 with a VALUE: Apple
ID: 2 with a VALUE: Orange
ID: 3 with a VALUE: BANANA
I wish to export the data VALUE, but currently can only pull out the ID.
For example, I want to export the words "APPLE", "ORANGE" etc - meaningful names, and NOT just "1", "2" etc.
My actual query line thus far....
SELECT ID,time,quote,media,pack FROM database_table_name
The issue is the 'pack' field renders the id numbers, not the real names on export. Any ideas how to access the real names instead??