I have a table like this :
maiL_client platform rendering_engine category
Android mobile Webkit read
Android mobile Webkit deleted
Apple iPhone mobile Webkit skimmed
Other Other desktop read
Other Other desktop deleted
Android Other mobile skimmed
Now what I need is to get the distinct values for all of these columns. Is it possible to get it in one query ? If I use simple SELECT DISTINCT column_names then it will geive duplicate values. I am using this in CodeIgniter active record pattern.