数据库模糊查询语句报错

Question

数据库查询语句报错了，不知道是哪个部分错了
代码片：

                con = DBUtil.getConnection();
                System.out.println("select * from group where member like '%"+email+"%'");
                System.out.println("select * from group where member = "+email+"");
                pst = con.prepareStatement("select * from group where member like '%"+email+"%'");
                ResultSet rs = pst.executeQuery();

控制台报错信息：

 select * from group where member like '[e-mail]%'
select * from group where member = [e-mail]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'group where member like '[e-mail]%'' at line 1

Answer 1

group是关键字，需要转义。如果是sql server，用[]，如果是mysql，用

 ``

`