#record has 'test' keyword on any position
session.query(User).filter(User.first_name.like('%test%')).all()
#record has 'test' keyword on first position
session.query(User).filter(User.first_name.like('test%')).all()
#record has 'test' keyword on last position
session.query(User).filter(User.first_name.like('%test')).all()
0 Comments