substr

drizzle_core::expr

Function substr 

Source 
pub fn substr<'a, V, E, S, L>(
    expr: E,
    start: S,
    len: L,
) -> SQLExpr<'a, V, Text, E::Nullable, Scalar>
where
    V: SQLParam + 'a,
    E: Expr<'a, V>,
    E::SQLType: Textual,
    S: Expr<'a, V>,
    L: Expr<'a, V>,
Expand description

SUBSTR - extracts a substring from a string.

Extracts len characters starting at position start (1-indexed). Preserves the nullability of the input expression.

§Example

ⓘ
use drizzle_core::expr::substr;

// SELECT SUBSTR(users.name, 1, 3) -- first 3 characters
let prefix = substr(users.name, 1, 3);