I’m currently trying to search a table for values containing the hat symbol (^).

When I search for a string, it works fine like so:

But when I search for the hat, it returns all rows:

I tried putting the hat in various apostrophes and speech marks with no success. Can somebody explain why this is happening and how I can fix it?