MySql – Way to update portion of a string?

by

I think this should work:

UPDATE table
SET field = REPLACE(field, 'string', 'anothervalue')
WHERE field LIKE '%string%';

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. UPDATE multiple rows with different values in one query in MySQL
  3. How to find similar results and sort by similarity?
  4. Multiple Updates in MySQL
  5. mysql update column with value from another table
  6. SQL order string as number
  7. update multiple rows using limit in mysql?
  8. Can MySQL replace multiple characters?
  9. MySQL/SQL: Update with correlated subquery from the updated table itself
  10. What are differences between INSERT and UPDATE in MySQL?
  11. MySQL UPDATE syntax with multiple tables using WHERE clause
  12. The best way to remove value from SET field?
  13. Strip last two characters of a column in MySQL
  14. Update MySQL with if condition
  15. Update multiple rows with multiple ‘where’ clauses for each individual row
  16. MySQL update statement to store ranking positions
  17. INSERT INTO SELECT statement with more columns which is not in another table
  18. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  19. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  20. Cumulative sum over a set of rows in mysql
  21. Add Auto-Increment ID to existing table?
  22. Using group by on two fields and count in SQL
  23. Can MySQL convert a stored UTC time to local timezone?
  24. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  25. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  26. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  27. How to get a list of months between two dates in mysql
  28. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  29. Postgres LEFT JOIN with WHERE condition
  30. How to check if field is null or empty in MySQL?

Leave a Comment