Check database for similar value , MySQL

Programming in mysql: Check database for similar value , MySQL on newest questions tagged mysql – Stack Overflow

I have a table server like this;

Model | Brand
-------------------
M4000 | Dell
S4000 | Hp
S3500 | Hp
S6500 | Sun

I want to display different data from the ‘Brand’ field which means I don’t want the second ‘Hp’ data to display again. How do I do that?

source: http://stackoverflow.com/questions/10223641/check-database-for-similar-value-mysql
Programming in mysql: programming-in-mysql