X
1
Search MySQL utf8 and latin1
SELECT * FROM tablename WHERE MATCH (name,description) AGAINST ('phrase' IN BOOLEAN MODE) or convert(cast(convert(name using latin1) as binary) using utf8) = 'phrase' or convert(cast(convert(description using latin1) as binary) using utf8) = 'phrase';
SELECT * FROM tablename WHERE MATCH (name,description) AGAINST ('phrase' IN BOOLEAN MODE) or convert(cast(convert(name using latin1) as binary) using utf8) like 'phrase' or convert(cast(convert(description using latin1) as binary) using utf8) like 'phrase';
rated 1 times
(1)
(0)
comments: 0 / hits: 1460
/ 4 years ago, thu, nov 16, 17, 07:47:54
More From
» SQL
Comments
There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 23
Total Comments: 2
Location: New Britain, Connecticut