My question is not as complicated as the query looks. I was noticing when double checking some values that there was an unusual false positive. I am grouping by the article titles so that only the rows pulled 2 times are displayed. In this case "Attendance program" and "attendance program" were considered to be the same since the titles were considered the same, however the titles for these two articles are actually different because in the first article the first letter of the title is capitalized where as in the second title the first letter is not capitalized.
SELECT article.title, article.ID, COUNT(*) AS count
FROM article, art_cat_relationships
(art_cat_relationships.cat_ID=22 OR art_cat_relationships.cat_ID=30)
GROUP BY article.title
HAVING count = 2
ORDER BY title
Any idea why these titles are considered the same and how to get the query to be case sensitive? I didn't see anything mentioned MySQL documentation about case sensitivity for this function.
Not that it's all that important, but this is for my new article tags page where results can be further narrowed by multiple tags.