not sure if i'm doing something wrong. but right now this SQL regex matching works for me url ilike '% youtube.com %' but the moment i change it to url ilike '%( youtube.com )%' it stops working. not being able to group is a bit of a handicap..

Hello! Are you querying a Postgres database? If yes, then I recommend you try the ~ operator which supports pattern matching with POSIX regular expressions. For example: url ~ '(youtube\.com|vimeo\.com)' -- case sensitive url ~* '(youtube\.com|vimeo\.com)' -- case insensitive ILIKE is a case-ins…

SQL regex () don't seem to work

💬 Queries and Resources

royston December 10, 2020, 6:39am 3

Thanks Jane. It’s a SQL query of JSON, that’s probably why () didn’t work?
~ operator didn’t as well.

Topic		Replies	Views
Ilike isn't working with the pattern matching condition 💬 Queries and Resources bug , sql	4	418	May 22, 2024
Error when running a query with ILIKE using Big Query 💬 Queries and Resources bug	7	1631	June 16, 2023
ILIKE, LIKE, etc giving me errors that I cannot seem to resolve 💬 Queries and Resources	10	3929	August 3, 2023
Double brackets not working as expected when querying jsonb column in postgres database 💬 Queries and Resources postgres	4	2010	August 2, 2023
"like" query with wildcards to postgres breaking for exact match 💬 App Building	4	3298	August 1, 2023

SQL regex () don't seem to work

Related topics