How can i use pattern matching in postgres

[newholder]

i want to find any name that contains string 'hy' or any othe string in then. So, i test the query, directly on the database like this:

SELECT * FROM namelist 
    WHERE name LIKE '%hy%'

and it works. then i tried in in prepared statement, like this:

let name = "hy"
sqlx::query_as(r#"SELECT * FROM namelist WHERE name LIKE '%$1%'"#)
    .bind(name)
    .fetch_all(pool)
    .await;

it returns empty. What did i do wrong. I can't find anything on the internet on how i can do this.

[newholder]

Human error, Just put the percentage in the bind, so

let name = "%hy%"
sqlx::query_as(r#"SELECT * FROM namelist WHERE name LIKE $1"#)
    .bind(name)
    .fetch_all(pool)
    .await;