You should write: SELECT postcode FROM TABLE_NAME;
This will display the postcode from your table? Jfernand ** sql ** -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: November 20, 2002 16:12 To: [EMAIL PROTECTED] Subject: SELECT Statement Question Hi I am a beginner in using mysql on Windows platform, and I have a question regarding the use of "SELECT * from TABLE_NAME" statement within the mysql prompt. I have a table of consisting of three columns POSTCODE, SUBURB, STATE where the primary key is a composite of all three fields. When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of data and some of my data is not shown. However when viewed from within a tool like PHP MYADMIN all the data is displayed correctly. Is this a bug or a limitation of mysql? Or am I doing something wrong? Any advice/help would be most appreciated. Thanks Best regards Boris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
