Like查询中出现换行符的问题

kider

给字段加个binnary就OK了：
SELECT * FROM authentication WHERE BINARY(DEVROLENAME) LIKE "1.0TR06%";

或者在update时加binary，也是可以的:
UPDATE authentication SET DEVROLENAME=BINARY('1.0TR069\r\n') WHERE id =8;