[][src]Trait diesel::prelude::EscapeExpressionMethods

pub trait EscapeExpressionMethods: Sized {
    fn escape(self, character: char) -> Escape<Self, AsExprOf<String, VarChar>> { ... }
}

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);

Provided methods

fn escape(self, character: char) -> Escape<Self, AsExprOf<String, VarChar>>

See the trait documentation.

Loading content...

Implementors

Loading content...