Link to home
Start Free TrialLog in
Avatar of sqlcurious
sqlcuriousFlag for United States of America

asked on

to update code in sql

Hi experts I need to update any string of a column with the following text = '%c/my/purchases.zx%'  to 'common/mybids.php'
Only 'c/my/purchases.zx' in the string should change to 'common/mybids.php', rest of the string should remain the same
Should I use replace function? please suggest
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sqlcurious

ASKER

thanks