I have code like this:
t = "%#{term}%"
where('name like ? or email like ? or postcode like ?', t, t, t)
As you can see it's performing a search across several fields.
Is there a way to avoid the duplicated t? It's making me feel dirty.
Thanks
You can do it with a named placeholder:
where('name LIKE :name OR email LIKE :name OR postcode LIKE :name', :name => t)
This is often the best way to repeat a singular value several times in a query.
t = "%#{term}%"
where('name || email || postcode like ?', t)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With