On this page

    Categories: String

    SIMILAR_TO

    Tests whether the entire expression matches a pattern.

    Syntax

    expression SIMILAR TO pattern → boolean

    • expression: The expression to compare.
    • pattern: The pattern that is compared to the expression.

    Examples

    SELECT 'shortcakes' SIMILAR TO '%cake_'
    -- True
    

    expression SIMILAR TO pattern ESCAPE escape_character → boolean

    • expression: The expression to compare.
    • pattern: The pattern that is compared to the expression.
    • escape: Putting an escape_character before a wildcard in the pattern makes SIMILAR TO treat the wildcard as a regular character when it appears in the expression.

    Examples

    SELECT '100%' SIMILAR TO '100!%' ESCAPE '!'
    -- True
    

    Usage Notes

    Succeeds only if the pattern matches the entire expression.