Use PostgreSQL LIKE % wildcards with RDS Data API?

Question

I'm using RDS Aurora Serverless with PostgreSQL compatibility. I'm trying to write a query that uses the [PostgreSQL LIKE clause](https://www.tutorialspoint.com/postgresql/postgresql_like_clause.htm) with percentage signs as wildcard operators. This is what I'm using right now:

```
SELECT * FROM products WHERE name LIKE '%:productName%'
```

and the productName gets passed into the RDS Data API through a `stringValue` field parameter (since it comes from user input).

```
{ name: 'productName', value: { stringValue: variableFromUserInput } }
```

This doesn't seem to be working since my query always succeeds but returns no results. Is this use case supported with the RDS Data API and am I using this correctly?

Accepted Answer

A parameter inside the quoted value like that doesn't look right. I haven't used this API... but I have used many analogous ones.

Try a test like this:

```
SELECT * FROM products WHERE name LIKE '%' || :productName || '%'
```

That's a more typical way to reference your parameter.

Use PostgreSQL LIKE % wildcards with RDS Data API?

Relevant questions

RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.

Choosing RDS PostgreSQL over Aurora PostgreSQL

Migrate snapshot option disabled

Changes to connection handling with Aurora Postgres?

Use PostgreSQL LIKE % wildcards with RDS Data API?

PostGIS and Aurora compatibility: experience feedback

PostgreSQL "to_timestamp" function in RDS Data Service command batchExecuteStatement

Invoke lamda async from Aurora PostgreSQL

Migrating RDS PostgreSQL to Aurora PostgreSQL in a different account

Move RDS postgresql database to Aurora Serverless