public Connection::escapeLike($string)
Escapes characters that work as wildcard characters in a LIKE pattern.
The wildcard characters "%" and "_" as well as backslash are prefixed with a backslash. Use this to do a search for a verbatim string without any wildcard behavior.
For example, the following does a case-insensitive query for all rows whose name starts with $prefix:
1 2 3 4 | $result = db_query( 'SELECT * FROM person WHERE name LIKE :pattern', array(':pattern' => db_like($prefix) . '%')); |
Backslash is defined as escape character for LIKE patterns in Drupal\Core\Database\Query\Condition::mapConditionOperator().
Parameters
string $string: The string to escape.
Return value
string The escaped string.
File
- core/lib/Drupal/Core/Database/Connection.php, line 1008
Class
- Connection
- Base Database API class.
Namespace
Drupal\Core\Database
Code
1 2 3 | public function escapeLike($string) { return addcslashes($string, '\%_');} |
Please login to continue.