how do u show a result once?

[union_jack]

I am using the below statment to bring back results for towns beginning with A to E.

SELECT * FROM data1 where town between 'A%' and 'E%' ORDER BY town

But because I multipule entries the results are for example:

Aberdeen
Aberdeen
Aberdeen
Abingdon
Abingdon

How do I get it to return just the one result per town?

Thanks for any help?

[SuzyUK]

try..
SELECT distinct FROM data1 where town between 'A%' and 'E%' ORDER BY town

[union_jack]

mmm.. got an error

Warning: Supplied argument is not a valid MySQL result

Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM golf where town between 'A%' and 'E%'

any ideas

[SuzyUK]

.. sorry try

SELECT DISTINCT 'town' FROM 'data1' where 'town' between 'A%' and 'E%' ORDER BY 'town'

forgot to put in town, but it's the "DISTINCT" that should get your one result.

[union_jack]

that's got it thanks for your help