Q:

how to remove single quote ' character in mysql text field?

This is my query:
SELECT count(email_details.id) as total_emails,
       email_titles.* 
  FROM email_details 
  LEFT JOIN email_titles ON email_details.email_title = email_titles.title 
 GROUP BY email_details.email_title 
 ORDER BY email_titles.id ASC

Now my problem is  email_details.email_title is blob field and email_titles.title is text field, 
both field has a data with ’ chracter say "this month’s video" when i runs this query without left join the row having ’ chracter does not retrieve,
if i put left join then it retrieves only first table data.
how to solve this problem?

A:

I have solved my problem by my self,
i have modified join code like this
LEFT JOIN `email_titles` ON CONVERT( email_details.email_title
USING utf8 ) = CONVERT( email_titles.title
USING utf8 ) 

