PEAR Manual
Prev |  | Next

# ->escape()

->escape() -- Escape a string for use with Like queries

## Synopsis

``void $DB_DataObject->escape` (string $value)`

## Description

Similar to Pear DB's quote it will escape a value, without the quotes, so it can be used with a LIKE query.

## Parameter

- `string $value` - the string you want to escape

## Note

This function can not be called statically.

## Example

Example 33-1. Escaping a LIKE string
    $person = new DataObjects_Person;
    $person->whereAdd("name LIKE '%" . $person->escape("o'brian") . "%'");
    $person->find();

Example 33-2. Sample SQL
    SELECT * FROM PERSON WHERE name LIKE '%o\'brian%'

Prev | Home | Next
->whereAdd() | Up | ->limit()