QueryStash
If you need to check an input string for one or many strings and not worry about case sensitivity, REGEXP_CONTAINS is a very easy method to do so. You can define a list of strings to search for by separating by | as in the example.
|
1REGEXP_CONTAINS(input_string, '(?i)(string_to_find_a|string_to_find_b)') 2 3-- EXAMPLE 4SELECT url 5FROM table_name 6WHERE REGEXP_CONTAINS(url, '(?i)(youtube.com|youtu.be)')
Blakey 🚀
Created: Apr 11th 2022
Made with ❤️ by @Yekalb
© 2024 Query Stash. All rights reserved
Resources
Examples
Stay up to date