How to remove all strings after question mark in MySQL query
I have a list of URLs like http://mydomain/app?u=asdfa&b=fnsn with different number of parameters. I want to remove all strings after the question mark and get different urls.
I have a list of URLs like http://mydomain/app?u=asdfa&b=fnsn with different number of parameters. I want to remove all strings after the question mark and get different urls.
P粉0142181242024-03-30 15:06:33
substring_index(url, '?', 1)
Will return everything before the first one? Or if not then the entire URL?