1 database.inc | public DatabaseConnection::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:
$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 DatabaseCondition::mapConditionOperator().
Parameters
string $string: The string to escape.
Return value
string: The escaped string.
File
- core/
includes/ database/ database.inc, line 1075 - Core systems for the database layer.
Class
- DatabaseConnection
- Base Database API class.
Code
public function escapeLike($string) {
return addcslashes($string, '\%_');
}