How can a SQLAlchemy query use MySQL's REGEXP operator?

Question

How can this SQL query:

SELECT * from table where field REGEXP 'apple|banna|pear';

be written using SQLAlchemy?

My base query looks like this:

query = session.query(TableFruitsDTO)

SuperShoot · Accepted Answer · 2020-03-12 07:41:52Z

10

The SQLAlchemy docs describe how to use the MySQL REGEXP operator. Since there is no built-in function, use .op() to create the function:

query = session.query(TableFruitsDTO).filter(
     TableFruitsDTO.field.op('regexp')(r'apple|banana|pear')
)

SuperShoot

11k3 gold badges45 silver badges63 bronze badges

answered Dec 1, 2014 at 13:19

davidism

128k31 gold badges417 silver badges348 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1