When running IN() in a MySQL query, you're able to use @BindList() in JDBI to run your query towards a list.
However, I'd like to do the same with MATCH() and REQUEST(), however I'm not able to construct a query that seems to work for this.
This was my old query:
SELECT * FROM xxxxxxxxxxx WHERE request_id NOT IN (<blacklistedRequestIds>)
And what I want to do is something like:
SELECT * FROM bcsadmin_log WHERE MATCH(request_id) AGAINST(-<blacklistedRequestIds> IN BOOLEAN MODE)
(IN BOOLEAN MODE) is something that ChatGPT told me to use, I think it isn't important for the actual question though.
Could anyone give me some support?