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(); 


Online demo:

// list of jokes
  https://johns-jokes.cf/home?app=4

// select any joke title from above
// images have yet to be displayed because URLs in database and link to another domain