I'm trying to make multiple tag search in my post tags.
So I have a table `tags_posts` (columns are `id_tag` and `id_post`).

If user types a few tag to input (I'll seperate and parse them using comma and array), sql query should return all posts that has all tags in user's input.

[Here's my database table](http://prntscr.com/17j3fs)

What I've tried:

`SELECT DISTINCT id_post, content, author_id, created, updated, username FROM tags_posts INNER JOIN posts ON posts.id=tags_posts.id_post INNER JOIN users ON users.id=posts.author_id WHERE id_tag IN (:tagids)`

But in this case if any"one" of :tagids has in any post, that posts returns. But I'm looking for all tags for that post.