Thu, December 2, 2021
 
https://devcodepro.comdevcodepro
X
InterServer Web Hosting and VPS
Home · Latest · Trends
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: 1534  / 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
Login with Google
 
Share
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 25
Total Comments: 2
Location: New Britain, Connecticut
Ronald snippets
5 years ago, tue, sep 6, 16, 10:11:38
comments: 0 / hits: 2659
PHP
5 years ago, tue, sep 6, 16, 10:18:23
comments: 0 / hits: 2504
PHP
5 years ago, tue, sep 6, 16, 10:42:24
comments: 0 / hits: 2896
PHP
5 years ago, fri, sep 16, 16, 1:10:12
comments: 0 / hits: 3371
PHP
5 years ago, fri, sep 16, 16, 1:12:32
comments: 0 / hits: 2186
CSS
5 years ago, fri, sep 16, 16, 1:27:33
comments: 0 / hits: 3322
PHP
5 years ago, sun, sep 25, 16, 2:52:42
comments: 1 / hits: 2645
5 years ago, thu, nov 10, 16, 4:21:59
comments: 1 / hits: 2799
PHP
5 years ago, mon, nov 21, 16, 10:48:23
comments: 2 / hits: 10218
PHP