[Solved] how to select duplicate record as one record in mysql

by

[ad_1]

You have to concatenate the two fields, and pass them together to the group by
as following

select 
 id, 
 concat(`field1`,`field2`) as `together` 
from table_name 
group by together

1

[ad_2]

solved how to select duplicate record as one record in mysql