Parameter with pattern matching syntax in a PostgreSQL query [duplicate]

Question

Iam writing a golang program in which i query postgres database. I want to to use $1 to supply values and should have a pattern matching

Db.Query("SELECT * FROM table where name like %$1%", user)

it says:

syntax error at or near "%"

I did like this to get output Db.Query("SELECT * FROM table where name like $1", "%"+user+"%") but isn't there any better and professional way to do it — Hardy
– Hardy, Commented Apr 14, 2016 at 10:35
it says syntax error at or near "%" I did like this to get output Db.Query("SELECT * FROM table where name like $1","%"+user+"%") but isn't there any better and professional way to do it — Hardy
– Hardy, Commented Apr 14, 2016 at 10:41
which package you use ? Give us more detail about what is user... As said here stackoverflow.com/questions/25214459/go-postgresql-like-query try to escape your like request like '%$1%' — Manawasp
– Manawasp, Commented Apr 14, 2016 at 10:43

p_mcp · Accepted Answer · 2016-04-14 10:56:37Z

2

Your syntax is wrong, try

user := "%"+user+"%"

rows, err := Db.Query("SELECT * FROM table where name like $1", user)

if err!=nil{
    fmt.Println(err)
}

answered Apr 14, 2016 at 10:56

p_mcp

2,8118 gold badges40 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1