Kerzo

Your best bet is to have three tables: 'posts', 'tags' and 'post_tags'. The structure of the Posts table remains the same. Tags is comprised of tagID and tagName columns. Post_tags links the tags in the Tags table to the appropriate Post using foreign keys on ID and tagID. This means that a post can now have multiple tags connected with it, retrieving other posts with the same tags is a lot quicker and it can also be done in a single SQL statement.