Sql like golang?

Question

MySQL

How to write a record like this safely:q = "%first page%"

db.Query("SELECT * FROM `page` WHERE `title` LIKE ?", q)

Or is it somehow possible?

db.Query("SELECT * FROM `page` WHERE `title` LIKE '%?%'", q)

Answer 1

The % signs must be in the data. Therefore, either on the application side add % around the edges of the line
Or on the sql side you collect:

db.Query("SELECT * FROM `page` WHERE `title` LIKE concat('%', ?, '%')", q)