Search result when searching content?

I have been doing the following search:

( Status = ‘new’ OR Status = ‘open’ OR Status = ‘stalled’ OR Status =
‘resolved’ ) AND ( Content LIKE ‘test’ )

This doesn’t return tickets that have ‘Test’ and not ‘test’ in them.
Shouldn’t it return all tickets if using LIKE? Is it a bug, or is it a
config item hidden away somewhere?

This is version 3.8.1.

Thanks.