I'm trying to get some analytics from eCommerce search tool. I'm looking to understand the usage in the search when looking for 6 digits code: 'XXXXXX' - could be 6 digits numbers only or 6 digits starting with A-Z letters.
I'm using Databricks (SQL), and this is my query:
SELECT search_phrase,
count(*) as search_cnt
FROM table
WHERE search_phrase Like '^[0-9]{1-6}$'
AND session_date BETWEEN '2022-11-01' AND '2022-12-01'
GROUP BY 1
But I'm not getting any results, could you help me solve this issue?
As mentioned above - the query attached
