I have a table containing multiple columns and I wish to obtain distinct records from one column e.g.
columns: id, address, city Table contains 7 entries with different id but only 2 cities in all 7 entries i.e. 5 x Madrid 2 x London I just want to obtain the list of the two cities With a regular mySQL expression you just simply state select distinct city.tablename from tablename
Me too! I need to do this as well. I have a database table which contains lots of labels. I want to generate a list of these labels from a certain field in the table, but I don't want to show duplicates (select DISTINCT it would be in SQL as Graeme has pointed out).
I guess in the mean time I could just create an SQL query to do that and then use the query with HTML5 DB...