SQL strings

regexp_replace(divide_lc_to_get_usd, '[a-zA-Z, ]+','','g')

• remove characters, comma, and space from value

Translate

????

Regex

select 'thomas' ~ 't.*ma';
+----------+
| ?column? |
|----------|
| True     |
+----------+

use LIKE if possible

• LIKE is part of the SQL standard
• ~ is non-standard

---

Last update: 2023-04-24