How to join array of Strings? SQLITE

Question

I want to make a join between the table people and vehicles, which both share this value,

in the people table the field is vehicles

["https://swapi.dev/api/vehicles/14/","https://swapi.dev/api/vehicles/30/"]

and in the vehicles table the field is url

https://swapi.dev/api/vehicles/14/

As you can see in the first one there is like a list of strings, how could I do the query? is sqlite

I tried this, but does not work

SELECT *
FROM people
INNER JOIN vehicles
ON people.vehicles = vehicles.url

also i see this post How to join array of strings? but it didn't solve my problem

SQLite does not support arrays. What is the actual data in the `vehicles` column in the `people` table? — Tim Biegeleisen, Jul 23 '21 at 05:11
@TimBiegeleisen this: `["https://swapi.dev/api/vehicles/14/","https://swapi.dev/api/vehicles/30/"]` thats the data — Dubbain, Jul 23 '21 at 15:40

score 0 · Answer 1 · answered Jul 23 '21 at 05:11

0

SELECT *
FROM people
INNER JOIN vehicles
ON people.vehicles like '%'+ vehicles.url  +'%'

answered Jul 23 '21 at 05:11

Tashil Moorateeah

Hi , that's return me nothing, does not work :/ please can keep me helping? – Dubbain Jul 23 '21 at 15:48
0 SELECT * FROM people INNER JOIN vehicles ON people.vehicles like CONCAT('%', vehicles.url ,'%') – Tashil Moorateeah Jul 28 '21 at 07:10

1 Answers1