MySQL – Replace Character in Columns

by

Just running the SELECT statement will have no effect on the data. You have to use an UPDATE statement with the REPLACE to make the change occur:

UPDATE photos
   SET caption = REPLACE(caption,'"','\'')

Here is a working sample: http://sqlize.com/7FjtEyeLAh

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. How to do a batch insert in MySQL
  4. Count the occurrences of DISTINCT values
  5. MySQL Trigger after update only if row has changed
  6. difference between primary key and unique key
  7. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  8. MySQL Query to select data from last week?
  9. How do I add a custom CHECK constraint on a MySQL table?
  10. Cast int to varchar
  11. Import SQL file into mysql
  12. How to insert data to MySQL with auto-incremented column(field)?
  13. How to change the default port of mysql from 3306 to 3360
  14. How to skip certain database tables with mysqldump?
  15. “where 1=1” statement [duplicate]
  16. Replace Into Query Syntax
  17. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  18. How to set a MySQL row to READ-ONLY?
  19. Laravel join with 3 Tables
  20. Difference between two table structure
  21. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  22. How to insert a file in MySQL database?
  23. How to get multiple records against one record based on relation?
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  27. How to speed up sql queries ? Indexes?
  28. MySQL: Computed Column
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment