Fri, August 7, 2020, 18:07:48
 
Home · Latest · Trends  /  SQL
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: 1137  / 3 years ago, thu, nov 16, 2017, 19:47:54
More From » SQL
 

Comments

There are no comments for this Snippet yet
Username
 
Your Comment
 
Share
Snippets
Using bind variables with ADODB
4 years ago, tue, sep 6, 2016
This module provides HTML and CLI interfaces for viewing key performance indicators of your database.
4 years ago, tue, sep 6, 2016
How to check if mail function is enabled on your server
4 years ago, tue, sep 6, 2016
Compare dates in smarty template file
4 years ago, fri, sep 16, 2016
Change default chrome input style CSS
4 years ago, fri, sep 16, 2016
Get domain name without Tld with PHP
4 years ago, fri, sep 16, 2016
Validating international phone numbers with jquery
4 years ago, sun, sep 25, 2016
Smarty Remove BBCode From String
4 years ago, thu, nov 10, 2016
How to detect if uploaded file is image or not with php
4 years ago, mon, nov 21, 2016
How to check CKEditor 4 textarea not empty
4 years ago, sun, dec 25, 2016
Posted
Ronald

Ronald

Member since Sep 6, 2016
Total Code Snippets: 22
Total Comments: 1
Location: n/a
Following
User not following anyone yet.