X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=src%2Fdb_mysql.pl;h=559ac2d2dca8cb2553f87cb313b76e42e3aa56b6;hb=99f86352e2eff21f5eef65c16c41b44e1bfa17b6;hp=266dd69f07eb534f4209f20309d8165054e0e6cd;hpb=857f3b7001b806dc469cb958d268f920a8017680;p=infobot.git

diff --git a/src/db_mysql.pl b/src/db_mysql.pl
index 266dd69..559ac2d 100644
--- a/src/db_mysql.pl
+++ b/src/db_mysql.pl
@@ -465,12 +465,14 @@ sub searchTable {
     }
 
     $str =~ s/\_/\\_/g;
-    $str =~ s/\?/\_/g;	# '.' should be supported, too.
+    $str =~ s/\?/_/g;	# '.' should be supported, too.
+    $str =~ s/\*/%/g;	# for mysql.
     # end of string fix.
 
     my $query = "SELECT $select FROM $table WHERE $key LIKE ". 
 		&dbQuote($str);
     my $sth = $dbh->prepare($query);
+    &DEBUG("query => '$query'.");
     &SQLDebug($query);
     if (!$sth->execute) {
 	&WARN("Search($query)");