Problem with Query Builder Not Returning Results for a LIKE Query

Hi everyone,

I've recently started working with CodeIgniter 4, and I'm encountering an issue with the Query Builder when using the LIKE clause. I'm trying to filter records from my database based on a search term, but it seems like the query isn't returning any results, even though I know matching records exist.

Here's a simplified version of my code:

Code:

$searchTerm = 'example';
$builder = $db->table('my_table');
$query = $builder->like('column_name', $searchTerm)->get();
$results = $query->getResult();

if (empty($results)) {
    echo "No records found";
} else {
    foreach ($results as $row) {
        echo $row->column_name;
    }
}

I've checked my database, and there are definitely rows where column_name contains the word 'example'. I've tried tweaking the query, but no luck so far. Could it be something related to how CodeIgniter 4 handles the like clause or perhaps an issue with the character encoding?

Any insights or suggestions on what I might be doing wrong would be greatly appreciated.
Thanks and Regards,
Elena Idioms

Check the real SQL statement that are executed by Debug Toolbar.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Could it be something related to how CodeIgniter 4 handles the like clause or perhaps an issue with the character encoding?

If you use an incorrect character encoding, yes, you would have issues.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper