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