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] > >
