I’m having a little problem making a dynamic Query using the QueryBuilder. I’m trying to make a Query with nested “LIKE” parameters to be compared between each other. Can this be done?
This is the Query I’m trying to produce:
SELECT id FROM `users` WHERE `deleted`=0 AND (`firstname` LIKE '%value%' OR `lastname` LIKE '%value%' OR `email` LIKE '%value%') AND `userroleId`=1
Obviously this isn’t right at all. I’ve been trying to fiddle around with different setups to make the middle part compare between each other but with no success. Would love some help. Maybe a manual custom Query is my only option?