Need Help With Specific Mysql Query

[telanor]

I need help figuring out exactly how I would write a mysql query that would do the following:

SELECT DISTINCT somefield FROM somedatabase WHERE something=something

and also select another field, the Id in this case, that goes along with the selected row. If I put "SELECT DISTINCT somefield, Id" I end up getting duplicate somefield entries

[monezz]

You need to specify which id you want from the distinct somefield.

you could use for example:

select max(id), somefield
from sometable
where someotherfield = somevalue
group by somefield