How to use Mysql's "regexp" or postgresql's "～*" ? #47

New Issue

lunny · 2019-02-19T02:03:10Z

lunny commented

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

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

lunny commented

Author: @lunny

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

Author: @lunny You can use `Expr()` or you can implement yours `Cond`.

lunny closed this issue

Sign in to join this conversation.

No Label

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/builder#47