php7.2
zencart 1.56c
mysql 5.7x

Not sure if this is a bug or by design -

When using the product search box to search through orders, results are only returned if the searched word or phrase is at the beginning of the product title.

For example, let's say I've sold some Blue Widgets and some Green Widgets. If I use the orders product search to find orders where I've sold "Widgets" (of any kind), I get no results at all because Widgets is not at the beginning of the product title.

Searching for "Blue Widgets" or "Green Widgets" works fine since those words appear at the beginning of the product title but searching for a word that is contained in the product title but is not at the beginning does not return a result.

Ed