can i use USE WILD CARD INSIDE REPLACE statement in MYSQL? : current data in table. COLUMN NAME IS URL
*******************
/abc1/pqr
/abc10/pqr

i need below result ie abc1 and abc10 should be replaced to xyz
*******************
/xyz/pqr
/xyz/pqr

HOW CAN I DO THIS USING REPLACE COMMAND AS I AM UNABLE TO USE WILD CARD INSIDE REPLACE statement ????
CURRENTLY I AM USING BELOW 2 STATEMENTS BUT I NEED A SINGLE STATEMENT....
*******************
UPDATE TABLE_URL
SET url = REPLACE(url, '/abc1/pqr', '/xyz/pqr')

UPDATE TABLE_URL
SET url = REPLACE(url, '/abc10/pqr', '/xyz/pqr')
*****************