joining of two mysql table with PHP in single query

Question

I have the following two tables. I want to join them in a single query.I am able to do it with inner join if the Blog_Category_Id in Blog table is a single value. But when it comes as a multiple value how can i do it?

First Table

Second Table

Below is the result table which i want to show...

Result Table

score 1 · Answer 1 · edited Feb 23 '18 at 08:41

1

SELECT b.* ,GROUP_CONCAT(bc.blog_category ORDER BY bc.id) blog_category
FROM blog b 
INNER JOIN blog_category bc ON FIND_IN_SET(bc.id, b.blog_category_id)
GROUP BY b.id

edited Feb 23 '18 at 08:41

Bedla

4,789
2
13
27

answered Feb 23 '18 at 07:39

vadher dinesh

11
3

Please consider to add some explanation and/or reference to documentation – Bedla Feb 23 '18 at 07:45

score 0 · Answer 2 · answered Feb 23 '18 at 05:23

0

You can you FIND_IN_SET in INNER JOIN Check here You may got answer

MySQL Join two tables with comma separated values

answered Feb 23 '18 at 05:23

SF..MJ

862
8
19

joining of two mysql table with PHP in single query

2 Answers2