I have the following
SELECT * FROM metadatas WHERE value IN ('Monumento', 'Arquitectura')
After making that query, it brings me several results, but I need to bring where both coincide. The result would be the following:
id - name - value
1 - Church - Architecture
1 - church - Monument
2 - Minimalist house - Architecture
The result I'm looking for is:
id - name - value
1 - Church - Architecture
1 - church - Monument
Because Minimalist House does not have a Monument value.