Thank you a lot Ravi. Ravi Kumar.-2 wrote: > > select distinct vehicle from <table_name> > > On 11/6/07, Jamessketch <[EMAIL PROTECTED]> wrote: >> >> >> Hello, >> >> I have a table that looks like this: >> >> vehicle | type | color >> car mercedes blue >> boat croater silver >> plane airbus red >> car volvo green >> car BMW white >> >> and when I you the SELECT statement to write down just vehicles is shows >> car >> boat plane car car. >> How can I have it in a way where repeating ones will NOT be shown? So I >> would have written just car boat plane. >> >> Thank you in advance. >> James >> -- >> View this message in context: >> http://www.nabble.com/Not-showing-repeating-fields.-tf4755269.html#a13598356 >> Sent from the MySQL - General mailing list archive at Nabble.com. >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> > >
-- View this message in context: http://www.nabble.com/Not-showing-repeating-fields.-tf4755269.html#a13603877 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
