summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Staff.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-01-17 10:47:48 +0100
committerYorhel <git@yorhel.nl>2015-01-17 10:47:48 +0100
commit5e60b5a9f5d3f7bb2458460de211492c329406b5 (patch)
tree761fd9320a51e764329096a8bac5c9b4479b7f84 /lib/VNDB/DB/Staff.pm
parent5bc52fc618cf200e82d320987a6c6829cf67bf1d (diff)
DB: No need to use double-%% in like queries
Diffstat (limited to 'lib/VNDB/DB/Staff.pm')
-rw-r--r--lib/VNDB/DB/Staff.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index 2c8dae93..a1728106 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -30,7 +30,7 @@ sub dbStaffGet {
# japanese character.
# note: more precise regex would be /[\p{Hiragana}\p{Katakana}\p{Han}]/
( q|(sa.original LIKE ? OR translate(sa.original,' ','') LIKE ?)| => [ '%'.$o{search}.'%', ($o{search} =~ s/\s+//gr).'%' ] ) :
- ( '(sa.name ILIKE ? OR sa.original ILIKE ?)' => [ map '%%'.$o{search}.'%%', 1..2 ] ) : (),
+ ( '(sa.name ILIKE ? OR sa.original ILIKE ?)' => [ map '%'.$o{search}.'%', 1..2 ] ) : (),
$o{char} ? ( 'LOWER(SUBSTR(sa.name, 1, 1)) = ?' => $o{char} ) : (),
defined $o{char} && !$o{char} ?
( '(ASCII(sa.name) < 97 OR ASCII(sa.name) > 122) AND (ASCII(sa.name) < 65 OR ASCII(sa.name) > 90)' => 1 ) : (),