1 Topic by prahousefamily (edited by prahousefamily 2017-02-12 10:20:52)

  • Registered: 2014-02-17
  • Posts: 365

Topic: How To USE function REGEXP in SQLITE

in MySQL have Function Regexp for search value in field
and sqlite have but i don't know how to edit or use

reference https://www.sqlite.org/lang_expr.html

Operators

SQLite understands the following binary operators, in order from highest to lowest precedence:

    ||
    *    /    %
    +    -
    <<   >>   &    |
    <    <=   >    >=
    =    ==   !=   <>   IS   IS NOT   IN   LIKE   GLOB   MATCH   REGEXP
    AND   
    OR

Supported unary prefix operators are these:

    -    +    ~    NOT
My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To USE function REGEXP in SQLITE

SQLite does not contain regular expression functionality by default.


more info:
http://stackoverflow.com/questions/5071 … lite-query

Dmitry.