diff options
| author | Yorhel <git@yorhel.nl> | 2020-07-29 11:08:03 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2020-07-29 11:13:14 +0200 |
| commit | 32b502511709afd45503779d5a1c38a1ada0f09c (patch) | |
| tree | 88fcd97965eecca8a391bea81ff518b2d84a1b7f /lib/VNWeb/Misc | |
| parent | daef605046269bcad26525c87d3e9a653db532c6 (diff) | |
SQL: Fix escaping of backslash in LIKE patterns
Diffstat (limited to 'lib/VNWeb/Misc')
| -rw-r--r-- | lib/VNWeb/Misc/ElmAnime.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Misc/ElmAnime.pm b/lib/VNWeb/Misc/ElmAnime.pm index cfcc1b1c..97260dd4 100644 --- a/lib/VNWeb/Misc/ElmAnime.pm +++ b/lib/VNWeb/Misc/ElmAnime.pm @@ -4,7 +4,7 @@ use VNWeb::Prelude; elm_api Anime => undef, { search => {} }, sub { my $q = shift->{search}; - my $qs = $q =~ s/[%_]//gr; + my $qs = sql_like $q; elm_AnimeResult tuwf->dbPagei({ results => 15, page => 1 }, 'SELECT a.id, a.title_romaji AS title, coalesce(a.title_kanji, \'\') AS original |