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
Query Builder and query "where (`field1` LIKE "%id1%" OR `field1` LIKE "%id2%") "
  • Query Builder and query "where (field1 LIKE "%id1%" OR field1 LIKE "%id2%") " . How?

  • ->where('field1', 'LIKE', '%id1%')->or_where('field1', 'LIKE', '%id2%') ?

  • Build with regexp and_where('field1', 'regexp', '[[:<:]]( id1|id2)[[:>:]]');

  • To artad : thanks , but before i use another where

  • @q2zx

    ->where('a','=','b')
    ->and_where_open()
         ->where('field1', 'LIKE', '%id1%')
         ->or_where('field1', 'LIKE', '%id2%')
    ->and_where_close()
    
  • To artad : thanks

Howdy, Stranger!

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

In this Discussion