No like in getResultArray

Try this because it works for me:

PHP Code:

 $db = \Config\Database::connect();

  $tmp = $data['title'];
  
  $sql = <<< ____TMP
    SELECT
      `xrl`, `title`, `memo`
    FROM 
      `jokes`
    WHERE
      `xrl` 
    LIKE
      "%$tmp%"      
____TMP;

  $query   = $db->query( $sql );
  $data['items'] = $query->getResultArray(); 


Thank you!

Search on the request works, I wrote about this in the beginning. I'm curious how to do this through $builder->like()...