Is there a way to select distinct records only?

Hi Graeme,
Can you please provide a little more detailed information about what you need to achieve? An example also will be good

Teodor

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

Thanks

Graeme

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

Hello,
Unfortunately distinct is not supported in the current version of the extension. I'm adding this into the wishlist for the upcoming updates.

Isn't this the same as the "group by" in the Data Bindings Formatter extension?