sql query to count tagged posts
===

I have a table of `newsPosts` where i have a column `tags` in that table.
tags column contains `comma(,)` seperated tags like this.

    tag1,tag2,tag3

in another table  i have list of all tags under tag column
like this :

   **tag**

    tag1
    tag2
    tag3
    tag4
    .
    .
    .
    . 


I want to find number of posts from news post table which are tagged with say tag2.


how can i do this ?  i am using `mysql 5.0`