How do you concat string input into a postgres query?

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}}' but the following attempts return errors

SELECT * FROM "User" u where like '%{{username}}' ;

SELECT * FROM "User" u where like CONCAT('%', '{{username}}', '');

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.

Hey Adam,

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

Hope that helps!