在开发中需要使用到 like 语句,代码如下:
sqlx.GET(&studentName,sqlx.Rebind("SELECT * FROM student WHERE name LIKE '%?'"),name)
但在运行的时候,出现数据语句错误!
在 stackoverflow给出了答案,此处作记录查找
- 解决方法一:
sqlx.GET(&student, sqlx.Rebind("SELECT * FROM student WHERE name LIKE ?"), “%”+name)
- 解决方法二:
sqlx.GET(&student, sqlx.Rebind("SELECT * FROM student WHERE name LIKE CONCAT('%',?)"), name)
- 解决方法三:
sqlx.GET(&student, sqlx.Rebind("SELECT * FROM student WHERE name LIKE '%' || ?"),name)