patindex looked hopeful, but I didn't realize that mysql does not have it. Is there another way I can go about this? The following works:
select replace(replace(replace(replace(replace(u.phone_number, ' ', ''), '-', '' ), '+', ''), '(', ''), ')', '' ) from prod.users u
inner join prod.groups g
on g.group_id = u.group_id
where g.country_billing_id = 1;
to take non-numeric characters out of a string, I just think nesting a bunch of replace statements looks messy. What could be a cleaner and more thorough way to go about this?
