mysql - Filter data on group by query -

sorry bad english. i've mysql query below:

select * messages id in (select max(id) messages group name) 

why query doesn't work:

select * messages id in (select max(id) messages field <> 'value' group name) 

thanks.