Text search with many keywords

[joethe66]

I have a table with mixed text information.
I have another table with names.
I would like to find those records in the table of mixed text which contain the names of the names table.

The tables are:

tb_Name

¦ID ¦ name       ¦
¦----¦--------------¦
¦ 0  ¦ JOHN/K   ¦
¦ 1  ¦ PETER/F ¦
…


tb_Account

¦ ID ¦   mixed_text               ¦ amount ¦
¦-----¦------------------------------------¦------------¦
¦ 0   ¦ WE0812 JOHN/K RLK      ¦ 190       ¦
¦ 1   ¦ WE0112 4D JOHN/K G12 ¦ 20    ¦
¦ 2   ¦ SHOP 1287        ¦ 300    ¦
¦ 3   ¦ KPM PETER/F      ¦ 10   ¦
…

The desired outcome would be:

tb_Account

¦ ID ¦   mixed_text               ¦ amount ¦
¦-----¦------------------------------------¦------------¦
¦ 0   ¦ WE0812 JOHN/K RLK      ¦ 190       ¦
¦ 1   ¦ WE0112 4D JOHN/K G12 ¦ 20    ¦
¦ 3   ¦ KPM PETER/F      ¦ 10   ¦

I tried to create some queries with no success:

SELECT “tb_Account”.*, “tb_Name”.“name” FROM “tb_Account”, “tb_Name” WHERE “tb_Account”.“mix_text” LIKE ‘%“tb_Name.name”%’

Any help would be greatly appreciated.

[Ratslinger]

Hello,

SELECT "tb_Account".* FROM "tb_Account", "tb_Name" WHERE "tb_Account"."mixed_text" LIKE '%' || "tb_Name"."name" || '%'

Tested using HSQLDB embedded &

Version: 7.2.4.1 / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US

Calc: threaded

[joethe66]

Thank you very much