Where contains

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 21, 2017   (RSS)

By Dave - November 21, 2017

HI ciaran_mac, 

What about: 

 'where'       => ' quality LIKE "%3%" ', // contains 3

Or if it's a multi-value field the values are tab separated so you can search like this so you match 3 and not 33:

 'where'       => ' quality LIKE "%\t3\t%" ', // contains 3

Let me know if that works for you!

Dave Edis - Senior Developer
interactivetools.com