replace some word in colum Sql mysql
How can i replace '¿¿¿' to 'ext' in column a
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
If '¿¿¿' is representing extensions then:
Update table TableName set a = (left(a,length(a)-3)+'ext'
Update table TableName set a = (left(a,length(a)-3)+'ext'
ASKER