How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)

Why doesn’t this work?

UPDATE wp_postmeta 
SET meta_value = REPLACE( meta_value, '$', '' ) 
WHERE meta_key LIKE 'price';

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. MySQL Error “Operand should contain 1 column”
  4. How to use MySQL DECIMAL?
  5. MySQL ERROR 1290 (HY000) –secure-file-priv option
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  8. MySQL DROP all tables, ignoring foreign keys
  9. Duplicating a MySQL table, indices, and data
  10. mysql Foreign key constraint is incorrectly formed error
  11. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  12. mysql is not recognised as an internal or external command,operable program or batch
  13. SELECT * FROM multiple tables. MySQL
  14. mysql: SOURCE error 2?
  15. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  16. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  17. Data truncated for column?
  18. MySQL foreach loop
  19. MySQL IF NOT NULL, then display 1, else display 0
  20. MySQL date format DD/MM/YYYY select query?
  21. MySQL Calculate Percentage
  22. Repair all tables in one go
  23. Error: select command denied to user ‘‘@’‘ for table ‘‘
  24. Get the new record primary key ID from MySQL insert query?
  25. #1214 – The used table type doesn’t support FULLTEXT indexes
  26. How to change collation of database, table, column?
  27. Failed building wheel for mysql-python
  28. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  29. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  30. Remove Primary Key in MySQL
  31. How to use the keyword ‘references’ in MySQL?
  32. How to get the max of two values in MySQL?
  33. mysql: connection refused when trying to connect to localhost using remote IP
  34. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  35. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  36. What are the recommended database permissions for WordPress?
  37. Complex meta query with 3 keys
  38. How can I find the source of slow queries in WordPress?
  39. How to log mysql errors from wordpress core?
  40. $wpdb and MySQL Create Trigger
  41. Fulltext search in posts sorted by relevancy
  42. wpdb Custom Meta Data with 2 conditions
  43. query to create woocommerce products from images
  44. How can I make wordpress suppress mysql errors?
  45. How to bulk delete all WordPress subscribers?
  46. Error while importing database
  47. What are the issues associated with upgrading MySQL for WordPress?
  48. Changing Table Prefix for an Existing WordPresss Site
  49. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  50. Connect another DB and fetch records from some tables
  51. Can I restart MySQL engine when WordPress website is live?
  52. Error: MySQL shutdown unexpectedly [closed]
  53. #1115 – Unknown character set: ‘utf8mb4’
  54. Why my wordpress loopback traffic while socket is setup?
  55. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  56. Update or insert meta key value – On Duplicate key update
  57. Connect to MySQL using Windows Authentication
  58. Defining the same price to all WooCommerce Products
  59. Database Structure on Different Servers
  60. Changing MySQL password via WHM – does this affect WordPress?
  61. How to get INSERT errors from $wpdb?
  62. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  63. Export Yoast Keywords from MySQL/phpMyAdmin
  64. Same database; different WordPress
  65. How to insert dash (-) into database using wpdb and new_to_publish hook?
  66. MySQL: How to change url in posts from xxx.com to yyy.org?
  67. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  68. WordPress unescape text on mysql?
  69. Getting data from Mysql Table..confusing
  70. Upgrade DB Loop – WordPress DB Version Conflict
  71. WordPress & MySQL , problem with use many array in meta_query
  72. mysql – Delete keyword with link from wordpress post database
  73. Button writing to MYSQL database
  74. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  75. DB option update with wp-cli
  76. MySQL ‘duplicate entry’ error
  77. WordPress Dutch characters encoding problem
  78. How to show result of sql query in a page?
  79. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  80. 403 Forbidden home on localhost with nginx server
  81. How do I insert content of various MySQL fields in post?
  82. Select latest 2 articles, but only from given category
  83. CONCAT_WS in custom sql query
  84. Query does not filter duplicate _sku numbers
  85. Ordering topics by most replies in X days using MYSQL statement
  86. MySQL Select within WP Page template
  87. #1115 – Unknown character set: ‘utf8mb4’
  88. wp_postmeta – lot of meta fields
  89. Running WordPress from MySQL Cluster with HAPRoxy
  90. Delete posts with word count less than x number of words
  91. MySQL: get post_tag items that are tags (not SEO keywords)
  92. $wpdb->get_var returns 0
  93. cannot log in to the mysql server (wamp and wordpress)
  94. SQL command to export post_content from wp_posts using phpMyAdmin
  95. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  96. Why does the MySQL command line tool ignore the –port parameter?
  97. How can I show user’s privileges in MySQL?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?