Issue Bug Closed

#23103It is not possible to search for '%' or '_' inside the Backend

Caspar Stuebs 07/05/10, 00:28 updated 03/12/14, 16:45

Description

Neither with the search-button in the Backend-Toolbar, nor within the Admin-Tool ‘DB check’ with the ‘full search’ function, it is possible to search for the chars ‘%’ and ‘_’.

Both functions does not escape the named chars for using inside the like-query, so they are interpreted as wildcards by sql.

Additionally the Toolbar-search does not use the function t3lib_db->searchQuery, which should be used for dbal support.

Solution:
adding t3lib_db->escapeStrForLike into t3lib_db->searchQuery
using t3lib_db->searchQuery inside the Toolbar-search (class.db_list.inc)

see patch
(issue imported from #M15001)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.