How to get records with exact match of desired values ​​in a many-to-many relationship with a single query?

Question

MySQL

Duplicate question.
How to get records with exact match of desired values ​​in a many-to-many relationship with a single query?

Answer 1

SELECT "CUSTOMVALUE1" as A 
UNION 
SELECT "CUSTOMVALUE2" as A

Answer 2

In what format does the data come from the client? JSON, XML? In any case, you can use the built-in DBMS libraries (MS SQL, ORACLE, etc) to translate incoming data into a table. Example on Oracle:

SELECT extractValue(value(t),'value') val, extractValue(value(t),'value/@id') attr
FROM TABLE(XMLSequence(XMLType('<form><value id="1">first</value><value id="2">second</value></form>').extract('form/value'))) t;

Answer 3

And what's the problem?
Cumbersomeness is not a criterion. The main thing is that the optimizer-scheduler understands how to execute the query.
Here if the request is fulfilled slowly - then it is necessary to think.