XF 2.3 Alternatives for using FIND_IN_SET?

[Newsman]

Hey there!

To check whether a value is in a column with multiple values (the secondary_group_ids column of the XF:User table for example), I often use a Finder with FIND_IN_SET via whereSQL.

Is there an actual native alternative to this that I haven't discovered yet? Like some kind of "contains" operator for the Finder?

Cheers!

 

[Jeremy P]

There's no shorthand for it, but if there were it would boil down to FIND_IN_SET anyway. You can always create a method for it (on your own finder for your own entity, or via a class extension for a core finder).