That's a lousy subject line, but I don't know how to describe this problem. I've been banging my head against this for a couple of days, and I'm certain there's a simple solution I'm missing.
I've got a URL table, a keyword table, and a joining table, so each URL has a list of keywords applied to it, and each keyword can be applied to many URLs: tbl_url ------- INT urlid, VARCHAR url tbl_keyword ----------- INT keywordid, VARCHAR keyword tbl_url_keyword --------------- INT urlid, INT keywordid How do I find all the tags that are tagged with the words "mysql" AND "databases" AND "tutorial"? It seems so simple, I can't believe it's caused me so much grief. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]