An SQL statement that is easy to write wrong in development

SELECT * from tableName where name = like '% Sugar sugar% '

Where it went wrong: name is followed by = and like

The cause of the error: copied over, the other place is =, did not delete directly added like

Error: Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax;  Check the manual-corresponds to your MySQL server version for the right syntax-use-like CONCAT (CONCAT ('% ', ' 1470622825427 '), '% ')

It technology and industry exchange Group 417691667

An SQL statement that is easy to write wrong in development