abhinav wagle
09/20/2022, 7:58 PM-
. Our field value includes the -
. Whats the right way to escape it. For example :
TEXT_MATCH(active_exp_map, '/.*9DtZjvh\-R/') - returns nothing.
vs
TEXT_MATCH(active_exp_map, '/.*9DtZjvh/') - returns data
Priyank Bagrecha
09/20/2022, 8:25 PMTEXT_MATCH(active_exp_map, '"9DtZjvh-R"')
i.e. phrase query worked in case anyone else is curious.