Logical AND in SQL statement

Question

I have a table which contains two columns, the first one contains a name and the second one contains a tag, so the name can have multiple tags, and the tags contains multiple names.

What I want to do is to write an SQL query that returns all the names that contains ALL the tags, which means that I must do AND operations in the SQL itself, my method takes a list that contains the tags, and it returns all the names that belongs to ALL tags, for example, If I passed 3 tags; A,B and C and there is a name has the tags: A and B, it will not be returned because it doesn't contains C.

Sorry. My bad. I'll remove my answer as it is most likely not relevant. "TOP 1" is a MSSQL convention. — smoore4, Jun 02 '16 at 08:58
@Bohemian My question is duplicated with http://stackoverflow.com/questions/1810356/how-to-implement-tag-system — hex, Jun 02 '16 at 09:09

score 0 · Accepted Answer · edited Jun 02 '16 at 08:29

0

I think that this will work:

SELECT Name FROM Table WHERE Tag IN ('list', 'of', 'tags') 
GROUP BY Name HAVING count(Name) = <counter of number of tags to Search>;

edited Jun 02 '16 at 08:29

Tom11

2,419
8
30
56

answered Jun 02 '16 at 08:15

Toni Cordon Batlle

16
1

Logical AND in SQL statement

1 Answers1