How to do a 'select like' usinf sqlalchemy?

[vrs762]

In sql syntax one can do select * from table where attribute like
'%value%'

However, how would one do that using the sqlalchemy's get/get_by
methods?

I tried different combinations but got only syntax errors.

Thanks in advance.

[Werner F. Bruhin]

Hi,

Just starting with SA, but what about something along these lines:

session.query(User).filter(User.name.like('%ed'))

or

session.query(User).filter_by(name='ed', fullname='Ed Jones')

Werner