Replies: 1 comment
-
You mean this? SELECT url LIKE '%event%' ? url : 'null' FROM {table} or just SELECT url FROM {table} WHERE url LIKE '%event%' |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi!
I'm not from a technical background and I'm new to GitHub as well as Clickhouse. Please bear with me!
I have a column called 'event_url' and it has various URLs.
Some URLs look like this : https://www.domain_name.com/event/*****
I was wondering if there's a way to create a column that has strings after '/event/'.
If there's no '/event/' in the url then it can output null.
It would be great if anyone could give me a clickhouse SQL query to do this. Please let me know if you need any more information. Thank you so much!!
Beta Was this translation helpful? Give feedback.
All reactions