LIKE ANY with asyncpg?

[FyZzyss]

Please tell me how you can make a LIKE ANY query in asyncpg?

My example: await pg.fetch(SELECT * FROM public.table WHERE field LIKE ANY($1::text[]), names_array)
Returns: []
SQL example: SELECT * FROM public.table WHERE field LIKE ANY('{%test%}'::text[]);

I also added \\% on both sides to each element of the array, but this does not work

[elprans]

I also added \\% on both sides to each element of the array, but this does not work

You have to add % (no need to escape it) to each element of names_array:

await pg.fetch(SELECT * FROM public.table WHERE field LIKE ANY($1::text[]), [f'%{n}%' for n in names_array])

[FyZzyss]

Thank you!