Any time there is an update within my music community (song comment, artist update, new song added, yadda yadda yadda), a new row is inserted in my "updates" table. The row houses the artist id involved along with other information (what type of change, time and date, etc).

My users have a "favorite artists" section where they can do just that -- mark artists as their favorites. As such, I'd like to create a new feature that shows the user the changes made to their various favorite artists.

How should I be doing this efficiently?

SELECT * 
FROM table_updates 
WHERE artist_id = 1 
and artist_id = 500 
and artist_id = 60032  

Keep in mind, a user could have 43,000 of our artists marked as a favorite.

Thoughts?