Query postgresql results with spaces

Hi how i can query in postgresql a value with spaces?

Lets say i have a text input with value = test again how i query that?

Where d.column1 ilike {{ ‘%’ + textinput1.value + ‘%’}} i tried that but it doesnt find the value test again

What im missing? @PeteTheHeat @ScottR

Hey @agaitan026! :slight_smile:

What database type are you using? And what is your query currently returning?