又一个MySQL坑

SELECT * FROM novel where title='一间客栈(连载)' ;
SELECT * FROM novel where title='一间客栈(连载) ' ;

SELECT * FROM novel where title=binary(‘一间客栈(连载)’ );
不加binary,MySQL会忽略大小写和首尾空格;

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注