84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
比如需要找出u_name中既有“三”又有“猫”的记录:SQL原生语句如下:
SELECT * FROM [user] WHERE u_name LIKE '%三%' AND u_name LIKE '%猫%'
请问这个如何在 SQLAlchemy 中实现呢
光阴似箭催人老,日月如移越少年。
from sqlalchemy import and_ words = ['%三%', '%猫%'] rule = and_(*[table.u_name.like(w) for w in words]) table.query.filter(rule)
DBSession().query(user).filter(user.u_name.like('%三%')).filter(user.u_name.like('%猫%'))
Or you can use and_()
and_()
DBSession().query(user).filter(and_(user.u_name.like('%三%'), user.u_name.like('%猫%')))
Or you can use
and_()