diff options
| -rw-r--r-- | app/Models/EntryDAO.php | 24 |
1 files changed, 16 insertions, 8 deletions
diff --git a/app/Models/EntryDAO.php b/app/Models/EntryDAO.php index 7cefc8c0e..424f682a8 100644 --- a/app/Models/EntryDAO.php +++ b/app/Models/EntryDAO.php @@ -978,18 +978,26 @@ SQL; if ($filter->getSearch()) { foreach ($filter->getSearch() as $search_value) { - $sub_search .= 'AND (' . $alias . 'title LIKE ? OR ' . - (static::isCompressed() ? 'UNCOMPRESS(' . $alias . 'content_bin)' : '' . $alias . 'content') . ' LIKE ?) '; - $values[] = "%{$search_value}%"; - $values[] = "%{$search_value}%"; + if (static::isCompressed()) { // MySQL-only + $sub_search .= 'AND CONCAT(' . $alias . 'title, UNCOMPRESS(' . $alias . 'content_bin)) LIKE ? '; + $values[] = "%{$search_value}%"; + } else { + $sub_search .= 'AND (' . $alias . 'title LIKE ? OR ' . $alias . 'content LIKE ?) '; + $values[] = "%{$search_value}%"; + $values[] = "%{$search_value}%"; + } } } if ($filter->getNotSearch()) { foreach ($filter->getNotSearch() as $search_value) { - $sub_search .= 'AND ' . $alias . 'title NOT LIKE ? AND ' . - (static::isCompressed() ? 'UNCOMPRESS(' . $alias . 'content_bin)' : '' . $alias . 'content') . ' NOT LIKE ? '; - $values[] = "%{$search_value}%"; - $values[] = "%{$search_value}%"; + if (static::isCompressed()) { // MySQL-only + $sub_search .= 'AND CONCAT(' . $alias . 'title, UNCOMPRESS(' . $alias . 'content_bin)) NOT LIKE ? '; + $values[] = "%{$search_value}%"; + } else { + $sub_search .= 'AND ' . $alias . 'title NOT LIKE ? AND ' . $alias . 'content NOT LIKE ? '; + $values[] = "%{$search_value}%"; + $values[] = "%{$search_value}%"; + } } } |