Skript db Sql LIKE search

[rburski]

So i dont know if im just stupid but i keep failing to do a like wildcard search.


execute "SELECT * FROM Active WHERE searchName LIKE '%%%arg-1%%%';" in {ah} and store the result in {_load::*}
im trying to get a auction search but it keeps returning none


if i do
execute "SELECT * FROM Active WHERE searchName LIKE '%%diamo%%';" in {ah} and store the result in {_load::*}
it works


here's my info
Server Version: 1.21.11-132-c5eb079 (MC: 1.21.11)
Skript Version: 2.16.1 (skriptlang-github)
Installed Skript Addons:
skript-gui v1.4.0 (https://github.com/APickledWalrus/skript-gui)
skript-yaml v1.7.2
SkBeePlusPlus v0.5.1
skript-reflect v2.6.3 (https://github.com/SkriptLang/skript-reflect)
skript-db v1.5.0
skript-simple-voice-chat v1.0.3
SkBee v3.25.3 (https://github.com/ShaneBeee/SkBee)
Skript-LuckPerms v1.0.3
Installed dependencies:
Vault v1.7.3-b131