hey, wondering if there a way to do TEXT_MATCh sea...
# general
c
hey, wondering if there a way to do TEXT_MATCh search for UUID prefix search. this is what i tried
Copy code
TEXT_MATCH(order_id, '"ae006b22-b5f"')
but it doesn’t return any data. if i tried
TEXT_MATCH(order_id, 'ae006b22-b5f0*')
it returns data more than started with
ae006b22-b5f0
. wondering what is the correct way to do it. thanks.
c
yeah. I tried.
not sure how to make it work
m
@Sidd ^^
s
Can you try
TEXT_MATCH(column, '\"ae006b22-b5f\"')
Ohh wait. You need exact phrase or prefix search ? I can get on a call tomorrow with you if you like. I vaguely remember someone else had encountered this quite some time ago and it worked
c
i actually need prefix search.
thanks Sidd. let me know when you have time.
m
Thanks @Sidd. Once we have the right pattern, could I request to update the docs?
👍 1