查询数据库,遇到特殊字符,如何解决呢?

 使用phpmyadmin 查询数据库:
 
select* form au_setting where sn=83:43:53:D1:FC:CC;

因为关键字中含有“:”,执行报错, 怎么才能解决这个问题呢?
 
分析时发现5个错误。

Unexpected character. (near ":" at position 35)
Unexpected character. (near ":" at position 38)
Unexpected character. (near ":" at position 41)
Unexpected character. (near ":" at position 44)
Unexpected character. (near ":" at position 47)
已邀请:

nero - 90后

赞同来自:

 加个引号'';
 
select* form au_setting where sn='83:43:53:D1:FC:CC';

要回复问题请先登录注册