How do you concat string input into a postgres query?

App Building
,
1

I am trying to make a simple query that takes in a variable and does a query with that variable and other text concated to it.

I want to search for the string '%{{variable}}%@mydomain.com' but the following attempts return errors

SELECT * FROM "User" u where u.email like '%{{username}}%@mydomain.com' ;

SELECT * FROM "User" u where u.email like CONCAT('%', '{{username}}', '%@mydomain.com');

This is an example of the error I get.

    • error:"bind message supplies 1 parameters, but prepared statement "" requires 0"

I feel like this should be very simple but I don't know the "Retool" way of doing it in a query.

2

Hey Adam,

When referring to variables, text inputs and similar within curlies you need to add .value i.e. {{username.value}}.

Hope that helps!