sql left join array to id

Asked Nov 02 '20 at 07:10

Active Nov 02 '20 at 07:35

Viewed 33 times

I need to find a solution to have multiple joins where the DB schema looks like that;

table a
array ["1","2","3"]

table b
id 1
id 2

i will need to left join each id to the array.

SELECT * FROM tbl_b LEFT JOIN tbl_a ON tbl_b.id=tbl_a.array

how can this be done?

edited Nov 02 '20 at 07:35

asked Nov 02 '20 at 07:10

deals4us3

How can a table have a field as array (Assuming field type is a string and you are adding data in the format of array.) – Mr world wide Nov 02 '20 at 07:13
its a text field so array looks like ["1","2","3"] – deals4us3 Nov 02 '20 at 07:20
I am using mysql DB – deals4us3 Nov 02 '20 at 07:35

0 Answers0