Discussion on: Best way to store array type data inside database?

[Florian Rand]

To retrieve a post and all its tags, you need to JOIN the tables in your queries

[Yashu Mittal]

On using the INNER JOIN clause it doesn't get the data if specific post have multiple tag_id

SELECT
    *
FROM
    post
INNER JOIN tag
ON post.post_id = tag.post_id;

it only return the data for 3rd row according to the above image.

[Florian Rand]

INNER JOIN tag

Can you see the mistake here?

You need to do the JOIN with the post_tags table (with both references, posts and tags) to work.

[Yashu Mittal]

Yeah I know that,

I tried with the both with and without post_tag table, it was return 0 rows.