Hi, i have a table (listProfiles) that has 3 fields (id, profile, list). Say i have 5 entries in that table.
I need to do a query where i get the profile (second column) that contains the list (third column) 1 AND 2 AND 3. IF i do do something like this :
it does not work. So i want the profiles (1 in my example) that have the list 1,2 and 3 in seperate entries. Is this possible?Code:SELECT * FROM listProfiles WHERE list=1 AND list=2 AND list=3