From 8802eac4f345f5a1d4fe8cf8e0b5ada3d9bc857e Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Thu, 24 May 2018 18:49:00 +0200
Subject: DB::Chars: Ignore spaces when matching original names

https://vndb.org/t950.432
---
 lib/VNDB/DB/Chars.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib/VNDB')

diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm
index db9ae93b..167ee223 100644
--- a/lib/VNDB/DB/Chars.pm
+++ b/lib/VNDB/DB/Chars.pm
@@ -42,7 +42,7 @@ sub dbCharGet {
     defined $o{weight_min} ? ( 'c.weight >= ?' => $o{weight_min} ) : (),
     defined $o{weight_max} ? ( 'c.weight <= ? AND c.weight > 0' => $o{weight_max} ) : (),
     $o{search} ? (
-      '(c.name ILIKE ? OR c.original ILIKE ? OR c.alias ILIKE ?)', [ map '%'.$o{search}.'%', 1..3 ] ) : (),
+      "(c.name ILIKE ? OR translate(c.original,' ','') ILIKE translate(?,' ','')) OR c.alias ILIKE ?", [ map '%'.$o{search}.'%', 1..3 ] ) : (),
     $o{char} ? (
       'LOWER(SUBSTR(c.name, 1, 1)) = ?' => $o{char} ) : (),
     defined $o{char} && !$o{char} ? (
-- 
cgit v1.2.3