How to remove all strings after question mark in MySQL query

Question

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.

Answer 1

substring_index(url, '?', 1)

Will return everything before the first one? Or if not then the entire URL?