I'm using RDS Aurora Serverless with PostgreSQL compatibility. I'm trying to write a query that uses the PostgreSQL LIKE clause 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?
Worked like a charm! It also inspired me to try adding the %s to the parameter itself which also works
{ stringValue: '%' + variableFromUserInput + '%'}