Hi there, Recently encountered an issue in queries to Postgres. Say you have a table with an entry: id = 1 name = ‘TEST_NAME’ select * from auth_group where name ilike ‘%TEST_NAME%’ The above query will yield no results in Retool, although does return you the record with ID 1 if queried to the…

Hi @gurpreetnanda ! This seems to work for me verbatim: [image] Is there a {{ }} tag being incorporated here? If so I normally use that like this: [image]

"like" query with wildcards to postgres breaking for exact match

💬 App Building

alex-w October 20, 2020, 5:17pm 4

Awesome! Glad to hear it

Topic		Replies	Views
Ilike isn't working with the pattern matching condition 💬 Queries and Resources bug , sql	4	400	May 22, 2024
Double brackets not working as expected when querying jsonb column in postgres database 💬 Queries and Resources postgres	4	2002	August 2, 2023
How to use a state variable in a LIKE postgres query 💬 Queries and Resources javascript , sql , postgres	5	7689	August 3, 2023
SQL queries behaving strange? 💬 Queries and Resources bug , sql , postgresql	4	80	October 7, 2024
Double Quotes Array in MultiSelect and Postgres Filter 💬 Queries and Resources	12	3271	September 24, 2024

"like" query with wildcards to postgres breaking for exact match

Related topics