hi
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 ?
thanks
What database are you using? You can use the WHERE clause to compare all three columns.
hi
im using mysql. i have done some queries whith the
where 'form_name' like name1
and
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
thanks
Hard to say without showing your table structure and an example.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
