[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

replace some word in colum Sql mysql

How can i replace '¿¿¿'  to 'ext' in column a
0
teera
Asked:
teera
3 Solutions
 
teeraAuthor Commented:
'¿¿¿'  mean extension
0
 
Rajkumar GsSoftware EngineerCommented:
You can use REPALCE function
UPDATE YourTable SET YourColumn = replace (YourColumn, '¿¿¿', 'ext')

Open in new window


This will update any records that is having '¿¿¿' with 'ext'

Raj
0
 
_agx_Commented:
The question isn't clear.  "¿" usually represents an unknown character. ie Like if there's an encoding problem and some characters can't be translated, they're replaced with "¿" (unknown).




0
 
jimyXCommented:
If '¿¿¿' at the end then:
Update table TableName set a = left(a,length(a)-3);
0
 
jimyXCommented:
If '¿¿¿' is representing extensions then:
Update table TableName set a = (left(a,length(a)-3)+'ext');
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now