Search and replace special characters (å,ä,ö) for image attachments only in database

Solved –

UPDATE wp_postmeta SET meta_value = REPLACE(REPLACE(REPLACE(meta_value, 'å', 'a') , 'ä', 'a') , 'ö', 'o')
WHERE LOWER(RIGHT(meta_value, 5)) = '.jpeg'
   OR LOWER(RIGHT(meta_value, 4)) IN ('.jpg', '.gif', '.png')

Related Posts:

  1. MySQL Database User: Which Privileges are needed?
  2. Database synchronization between dev/staging and production
  3. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  4. Safest way to bulk delete post revisions
  5. How can I make a WordPress database portable and url independent?
  6. Why does $wpdb return strings for mysql integer values?
  7. Dealing with Many Meta Values, 30+
  8. When is it appropriate to create a new table in the WordPress database?
  9. Special characters in WordPress UTF-8 [closed]
  10. Is it possible to switch the data layer within WordPress?
  11. store simple data in get_option()
  12. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  13. Have multiple local wordpress installs share a wp-content folder and database
  14. How to implement content from external database into WordPress text page? [closed]
  15. Cloning and syncing a WordPress website
  16. What actions affect files, DB, or both?
  17. Add search Value to wp_list_table pagination
  18. How to fix unchanged URLs in Database after running serialized search and replace script?
  19. Merging WordPress posts from different databases
  20. Should non-WordPress data get its own DB?
  21. Who is responsible for data sanitization in WordPress development?
  22. Localhost to Staging to Development Dynamic WP-CONFIG
  23. Setup 3 Sites To Connect To 1 Database and Share Data
  24. Uknown meta entries in wp_postmeta
  25. creating new field on mysql
  26. Why user_pass column in wp_users table is varchar(64)
  27. Can local WordPress installs share /wp-content/ folder and database?
  28. SymmetricDS in dev + prod workflow?
  29. Search Character Set Problem
  30. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  31. Character encoding issue – black diamond question marks on imported post excerpts
  32. WPCLI search and replace in a particlar site dir effect another site-dir
  33. Merging development site with live site
  34. WordPress character set issue
  35. One WP Database outside localhost and two connections
  36. Why is converting my database to UTF-8 truncating entries?
  37. Get id from database
  38. Share WordPress Database
  39. MySQL Database User: Which Privileges are needed?
  40. What is the difference between an ORM and an ODM?
  41. Rename a table in MySQL
  42. How should I tackle –secure-file-priv in MySQL?
  43. Keeping WP database synced across multiple developers using git
  44. Checking if Database Table exists
  45. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  46. Is it possible to define two databases for one installation?
  47. Connect forms in WP to external database
  48. Hook into $wpdb
  49. Is it wise to delete post revisions and autosaves from database?
  50. Improve or optimize a very slow query
  51. What is the advantage of separating wp_users and wp_usermeta table?
  52. “MySQL server has gone away” since update to 3.8
  53. Using two different DB users on one WP install
  54. Usage of Direct Database Call Without Caching Error
  55. Custom search page and search by title, content and tag
  56. Can I transfer a mysql database to another site?
  57. MySQL Syntax Error upon restoring database from backup [closed]
  58. Merge two databases: OLD SITE -> NEW SITE
  59. Backup another database with BackUpWordPress plugin [closed]
  60. Easiest Way to Authenticate WP Users Using an External DB?
  61. Moving WP from local server to live, error establishing a db connection
  62. Is there a way to see history of WordPress database changes?
  63. Where does the actual data stored by add_post_meta
  64. Exporting table to csv works in the admin but exports HTML data when used on the front end
  65. wp search-replace (not executing)
  66. How to have an external DB read and get data from my wordpress database
  67. Import users from old WP site to new one
  68. How to use default WP form elements to interact with custom DB table?
  69. SSO system between 2 WordPress installs on different servers
  70. is $wpdb->get_results() safe enough
  71. Does post_meta data need to be unserialzed?
  72. Can’t update WordFence Options, clear data manually
  73. Is it possible to have more than 1 MySQL database in my WordPress blog?
  74. How to fetch records from database WordPress
  75. Check & remove special characters in a field?
  76. AJAX wp-mysql running too slow
  77. Delete/Replace words from X to Y in post content
  78. Location of image metadata on my server
  79. How to create more than one new wpdb object?
  80. Multiple WordPress sites installs sharing the same database but with different content and domains
  81. Brandoo WordPress Unable to Update to WordPress 4.2.2
  82. Remote database -> massive response time increase?
  83. Custom Post Type not showing anything added by code anymore?
  84. Database tables for sports betting integrated in WordPress
  85. How to edit custom table data in frontend
  86. Unable to login to a https website via the app after changing from http
  87. mysqli_query(): MySQL server has gone away for Curl Request
  88. WP website showing blank page after moving from subdomain to main domain
  89. create a table using user meta custom data
  90. wpdb query to insert images in to post/page gallery
  91. How to create a database table?
  92. Database error after importing WordPress
  93. Send data to database after redirect (and popping out of iframe)
  94. Pulling values from a sepcific row in table
  95. import (migration) user database to wp-users
  96. Create hundreds of users with just ID in phpMyAdmin
  97. What is best for saving lot of extra detail of user?
  98. Insert Extra fields added in the front end registration form to DB
  99. WordPress Multisite platform for different city for single db
  100. How to create a table [closed]