Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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