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

[walnut-tom]

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

[lunny]

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