Kysely•4mo ago

How to do `LIKE ANY` query in Kysely?

Hello, I am trying to build this query in Kysely but have no idea how to properly insert the ANY into the query.

SELECT *
FROM your_table
WHERE your_column LIKE ANY (ARRAY[
    '%suffix1',
    '%suffix2',
    '%suffix3'
]);

SELECT *
FROM your_table
WHERE your_column LIKE ANY (ARRAY[
    '%suffix1',
    '%suffix2',
    '%suffix3'
]);

Any constructs with kysely that I should use in particular?

2 Replies

decho•4mo ago

you can try something like this: https://kyse.link/0RE11 However, I am not sure this is the best possible way to do this. Not particularly happy I had to use sql for the array.

koskimas•4mo ago

Did you try this https://kyse.link/IkXH9 ? I'm not sure if pg handles the array correctly

Gaming

Programming

How to do `LIKE ANY` query in Kysely?