Postgres Query with LIKE and EQUAL TO

Question

I'm trying to write a query with LIKE and = conditions:

Model.where("extract(day from month) = ? OR lower(name) LIKE ?",params[:filter], "%#{params[:filter]}%".downcase )

I get return for the month value but i don't get any return for the name value.

so how can i use 'LIKE' and 'EQUAL TO' together in one query?

[EDIT] : when i use only the like statement it works fine.

Did you check, if there are any records getting returned when you only apply like query? — Vishal Jain
– Vishal Jain, Commented Jul 19, 2022 at 8:26

Payal · Accepted Answer · 2022-07-19 10:15:45Z

0

We can definitely use like and equal to in the same query. Your query looks correct. Please check with hardcoded values to double check ex: Model.where("lower(name) LIKE ?", "%aManda%".downcase ) and then same for both conditions together.

edited Jul 19, 2022 at 10:15

answered Jul 19, 2022 at 10:14

Payal

4043 silver badges6 bronze badges

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

3 Comments

Atekelt Afework Over a year ago

when i use only one LIKE or multiple LIKE with OR/AND it works the problem is when i mix LIKE and EQUAL at the same time

Payal Over a year ago

Can you share exact query which does not work to demonstrate "i mix LIKE and EQUAL at the same time" ?

Atekelt Afework Over a year ago

Model.where("extract(day from month) = ? OR lower(name) LIKE ?",params[:filter], "%#{params[:filter]}%".downcase )

Collectives™ on Stack Overflow

Postgres Query with LIKE and EQUAL TO

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related