How to execute Cross join using Raw Query?

I have an SQL query that I want to convert to Laravel DB Query. But, I am unsure how to use Raw Query for Cross Joins.

SELECT DISTINCT json_t.id
FROM my_table,
  JSON_TABLE(my_table.array_ids, "$[*]" COLUMNS(id char(36) PATH "$")) AS json_t
WHERE my_table.array_ids IS NOT NULL

Can someone please help me to convert this query into Laravel DB Query?

Sinnbeck

4 years ago

Best Answer

Level 102

DB::selectRaw('SELECT DISTINCT json_t.id
FROM my_table,
  JSON_TABLE(my_table.array_ids, "$[*]" COLUMNS(id char(36) PATH "$")) AS json_t
WHERE my_table.array_ids IS NOT NULL')->get();

1 like

Please or to participate in this conversation.