jeremydaly / data-api-client

A "DocumentClient" for the Amazon Aurora Serverless Data API
MIT License
446 stars 63 forks source link

SELECT QUERY Contains or Like #19

Closed Bilonik closed 5 years ago

Bilonik commented 5 years ago

Hi,

How can we make a Select query with contains or like?

Great npm! Thanks

Bilonik commented 5 years ago

Resolved:

let resultParams = await data.query( SELECT * FROM cp WHERE status = :status AND name LIKE :search, { status: 1 , search: '%'+searchTerm+'%'} )