sqlcurious
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER