need to show the duplicates on a column table when they have two other values in common on other column.

form_name + field_value
name1 | value_x
name2 | value_y

how can i create the query to search when values x, y, etc have form_name name1 and name2 ?


What database are you using? You can use the WHERE clause to compare all three columns.

im using mysql. i have done some queries whith the
where 'form_name' like name1
where form_name like name2
but the results are returning values even if they are recorded only as name1 or name2.
but what i need to see is when they have the name 1 and 2 at the same time


Hard to say without showing your table structure and an example.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.