Trait diesel::expression_methods::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...