Mysql Query Check The Blob Column Type In Where Clause

I found out that CONVERT(object USING utf8) is for converting blob to text, but it doesn't seem efficient in the where clause, like this: Select * from Page where CONVERT(Page.pa

Solution 1:

I tried this and it worked:

Select * from Page where Page.page_title = 'AccessibleComputing'

I think after all it doesn't need any conversion.

Solution 2:

Do these work?

Select *, CAST(Page.page_title AS CHAR(10000) CHARACTER SET utf8) AS Tmp
from Page
where Tmp = 'AccessibleComputing'

OR

Select *, CONVERT(Page.page_title USING utf8) AS Tmp
from Page
where Tmp = 'AccessibleComputing'