CODEWITHSUNDEEP
mysqlsearchvarbinary
Adam Meyer
Adam Meyer

Reputation: 1525

MySQL case insensitive search on varbinary field?

I have a varbinary field id like to do a case-insensitive search on.

I know that the way varbinary fields work prohibits you from doing something like so:

WHERE LOWER(page_title) = LOWER("Gasket")

So is there a way to do this? I imagine I could temporarily cast the field as a varchar or something. But I'm not sure.

Upvotes: 8

Views: 5332

Answers (1)

Mike
Mike

Reputation: 21659

You can use the CONVERT() function:

SELECT * FROM mytable WHERE CONVERT(page_title USING latin1) = 'gasket';

See also Case Sensitivity in String Searches

Upvotes: 18

Related Questions