mySql无法查找ip格式的字段解决

问题：

select * from xxx_table where ins_ip = 192.168.10.110;

 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.10.110' at line 1    0.000 sec
 

解决：

给ip加上引号

select * from xxx_table where ins_ip = '192.168.10.110';

如果是变量则可以：

`select * from xxx_table where ins_ip = ${ip}`; // 出错
`select * from xxx_table where ins_ip = '${ip}'`; // 正确