Trait diesel::prelude::EscapeExpressionMethods

source · [−]
pub trait EscapeExpressionMethods: Sized {
    fn escape(self, _character: char) -> Escape<Self>;
}
Expand description

Adds the escape method to LIKE and NOT LIKE. This is used to specify the escape character for the pattern.

By default, the escape character is \ on most backends. On SQLite, there is no default escape character.

Example

let users_with_percent = users.select(name)
    .filter(name.like("%😀%%").escape('😀'))
    .load(connection);
let users_without_percent = users.select(name)
    .filter(name.not_like("%a%%").escape('a'))
    .load(connection);
assert_eq!(Ok(vec![String::from("Ha%%0r")]), users_with_percent);
assert_eq!(Ok(vec![String::from("Sean"), String::from("Tess")]), users_without_percent);

Required Methods

See the trait documentation.

Implementors