builder icon indicating copy to clipboard operation
builder copied to clipboard

How to use Mysql's "regexp" or postgresql's "~*" ?

Open walnut-tom opened this issue 6 years ago • 1 comments

mysql: select * from user where name regexp '^tom'; postgresql: select * from user where name ~* '^[a-h]'

walnut-tom avatar Feb 19 '19 02:02 walnut-tom

You can use Expr() or you can implement yours Cond.

lunny avatar Feb 19 '19 02:02 lunny