(Flask-SQLAlchemy) How can I check if multiple columns are LIKE a value?

Asked Jul 28 '22 at 23:12

Active Jul 28 '22 at 23:14

Viewed 15 times

I tried to match all users that have the value of 'user_like' in their username or tag by using filter with multiple arguments but it didn't work :

matched_users = User.query.filter(
      User.username.like(f'%{user_like}%'),
      User.tag.like(f'%{user_like}%')
    ).all()

I searched but didn't find any way of doing so, thanks for your help

edited Jul 28 '22 at 23:14

Yaakov Bressler

9,056
2
45
69

asked Jul 28 '22 at 23:12

TheGabDooSan

@YaakovBressler Oh yeah that helps a lot, I feel dumb that I didn't think about the or operator, thank you ! – TheGabDooSan Jul 28 '22 at 23:18
1

That's ok, we're all here to learn. – Yaakov Bressler Jul 29 '22 at 11:49

(Flask-SQLAlchemy) How can I check if multiple columns are LIKE a value?

0 Answers0