mysql中 select * from xxx where xxx.ttt like '%~%' 是什么意思

Question

mysql中 select * from xxx where xxx.ttt like '%~%' 是什么意思

数据库编码 GBK

Answer 1

When the database encoding is GBK, there is a bug in mysql, so the sql will not be executed correctly
The specific performance is
Contents containing ~ and containing Y will be searched.

Answer 2

Query the xxx table with fuzzy conditions in the ttt field. .
% represents any character
That means 123~456, abc~def, all of these can meet the conditions

Answer 3

RTFM

http://dev.mysql.com/doc/refman/5.6/e...