How can I replace $$ with $ where its part of field in MySQL ?

I've just noticed I have $$ at the start of all my prices.

I need to correct this, so that I have $ instead.

I need an update query to fix this..
mindwarpltdAsked:
Who is Participating?
 
Bhavesh ShahLead AnalysistCommented:
GENERALLY IT IS LIKE

UPDATE TABLENAME
SET COLUMN1 = REPLACE(COLUMN1,'$$','$')
where column1 like '%$$%'
0
 
waltersnowslinarnoldCommented:
Use the following code sample
UPDATE TableName
SET COLUMN1 = REPLACE(COLUMN1,'$$','$')
WHERECOLUMN1 like '$$%'

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.