aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb/db/driver/sqlite3.php
diff options
context:
space:
mode:
authorGeolim4 <contact@geolim4.com>2014-08-09 15:04:39 +0200
committerGeolim4 <contact@geolim4.com>2014-08-09 15:04:39 +0200
commit635cde218c786f76397c3354e59f96a8a151c132 (patch)
tree89f35826894637a4d0c5f30fef8cd2bf7469f8f7 /phpBB/phpbb/db/driver/sqlite3.php
parent4c06467777547d72a6ea936d024d85cae701189b (diff)
downloadforums-635cde218c786f76397c3354e59f96a8a151c132.tar
forums-635cde218c786f76397c3354e59f96a8a151c132.tar.gz
forums-635cde218c786f76397c3354e59f96a8a151c132.tar.bz2
forums-635cde218c786f76397c3354e59f96a8a151c132.tar.xz
forums-635cde218c786f76397c3354e59f96a8a151c132.zip
[ticket/12671] Possibility to use NOT LIKE expression
PHPBB3-12671
Diffstat (limited to 'phpBB/phpbb/db/driver/sqlite3.php')
-rw-r--r--phpBB/phpbb/db/driver/sqlite3.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/phpbb/db/driver/sqlite3.php b/phpBB/phpbb/db/driver/sqlite3.php
index f79245afb1..2bf4ed51aa 100644
--- a/phpBB/phpbb/db/driver/sqlite3.php
+++ b/phpBB/phpbb/db/driver/sqlite3.php
@@ -281,14 +281,14 @@ class sqlite3 extends \phpbb\db\driver\driver
*/
public function sql_not_like_expression($expression)
{
- // Unlike LIKE, GLOB is case sensitive (unfortunatly). SQLite users need to live with it!
+ // Unlike NOT LIKE,NOT GLOB is case sensitive (unfortunatly). SQLite users need to live with it!
// We only catch * and ? here, not the character map possible on file globbing.
$expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);
$expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);
$expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);
- return 'GLOB \'' . $this->sql_escape($expression) . '\'';
+ return 'NOT GLOB \'' . $this->sql_escape($expression) . '\'';
}
/**