TIP: Use Markdown or, <pre> for multi line code blocks / <code> for inline code.
These forums are read-only and for archival purposes only!
Please join our new forums at discourse.kohanaframework.org
Add FIND_IN_SET
  • The current implementation of FIND_IN_SET doesn't return properly. It's more of a work around, but I dont see of any other way of doing it.

    Basically you've got a set of data in a column (1,2,3) and you want to find the 3.

    SELECT * FROM table WHERE FIND_IN_SET(3,column)

    The CRUD builder work around works as to make the SQL:

    ->and_where(DB::expr('FIND_IN_SET(3,column)'),'=',true)

    SELECT * FROM table WHERE FIND_IN_SET(3,column) = '1'

    Either I'm doing it wrong (possible) or we need to add a way to do this.

  • @cs278 - that totally worked. Thanks!

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion