Selecting records from the database according to the list of labels specified in another table?

Question

SQL

MySQL has a table with records, also in a separate table are “record id” - “tag id”, which indicate which tags the indicated record has.
You must select entries by user-defined tags. In this case, there can be several tags in the request, and in this case, all records containing at least one of the tags listed in the request are selected.
The option in which a separate field is created for each label in the record table is not suitable, because. if necessary, you need to add a new label without changes in the sql query code.
Tell me, what sql-query to make such a selection?

Answer 1

select Record from TableWithRecords where idRecords in (select idRecords from TableTagged where idTag = 'desired tag')

Answer 2

SELECT r*
    FROM Records
    INNER JOIN Record_Tag rt ON rt.record_id = r.id
    INNER JOIN Tag t ON t.id = rt.tag_id
    WHERE t.name IN ('tag1','tag2','tag3,...,'tagN')

Selects all records (not unique) by tags, in order to select unique you need to add DISTINCT, or grouping, depending on how you are going to use this data.

Answer 3

Do you want each tag to be a separate field in the final table? Or a separate entry?