Mysql like

[donboe]

@ClauASRibeiro

You can try and use a case insensitive collation on your query, like COLLATE UTF8_GENERAL_CI.

Try

$sql = “SELECT O.order_date
, C.name
FROM offline_orders O
JOIN customers C ON O.customerid = C.customer_id
WHERE C.name LIKE :term COLLATE utf8_general_ci”;

This should do the trick.

That works great. Thanks a lot