How do I update a WordPress wp_postmeta meta_value that contains many options

What you are trying to do is access a property inside a serialized object. Well, this cannot be down directly. The data you have are serialized that’s why updating with the _sfwd-courses_course_access_list will not work as this is only inside the meta_value of the entry.

You have to unserialize update and then save with update_post_meta function.

Related Posts:

  1. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  2. Oracle SQL query for Date format
  3. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  4. Can I have multiple primary keys in a single table?
  5. Using wpdb to connect to a separate database
  6. Database connection close
  7. How to create bulk page and content? [closed]
  8. Importing posts from old website to new conflicting post ID’s?
  9. Exporting revisions
  10. WP_Options ID high
  11. Transient RSS feeds in wp_options not removed automatically?
  12. Best way to move live site local
  13. The revisions table in my database is at 70% capacity and growing. What should I do?
  14. WordPress for a very large website
  15. How to use multiple database in wordpress?
  16. Database location in WordPress
  17. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  18. WP_list_table bulk_action get edit and delete
  19. How to display data from custom table in wordpress database?
  20. Is removing orphaned wp_postmeta records safe?
  21. Change SQL get_results to search for posts with custom term in custom taxonomy
  22. Add search Value to wp_list_table pagination
  23. stdObject stored in database. How does one convert it to usable format?
  24. I have a table I created, how do I make a form for a user to filter the data?
  25. What ALL can cause “Another update is currently in progress.”? [closed]
  26. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  27. Set Display Name to first and last name (phpmyadmin SQL Query)
  28. Trigger Plugin database update after git pull
  29. Does WordPress ever need multiple databases?
  30. Why are no posts showing despite my apparently correct DB restoration?
  31. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  32. Cannot update custom database table row
  33. SQL Error wp_commentmeta – incorrect table definition
  34. Change WordPress prefix for only one table?
  35. Two websites one database, administrator not working on second website
  36. Multiple wp_options tables to share content across installs
  37. Select two sums with single get_var statement
  38. How to get the SQL of the changes made to the database from an update or upgrade?
  39. How can i add custom fields into the contact form 7 [closed]
  40. Is there a smart way to obtain a list of only some selected user meta data?
  41. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  42. Make an Items attribute searchable (taxonomy using existing attribute)
  43. Store partial database to an archive database time to time
  44. Move out of sync posts from one database to another
  45. Saving zero as meta value
  46. Migration: Copying database content to a different server
  47. Remove empty rows from the database
  48. Custom WordPress Table wpdb
  49. Check if post id exist in table than only update instead of inserting new row
  50. Detail explanation of wordpress database fields and metatag list [closed]
  51. CreateOrUpdate in WordPress
  52. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  53. How to convert srcset links from https to http?
  54. How to get a list of WordPress default database tables?
  55. Can local WordPress installs share /wp-content/ folder and database?
  56. How to transfer from localHost to live but use the already existing database on the server?
  57. Backing up WordPress database and files
  58. Safely store code(html/js..) into database
  59. Creating and Using Tables in the WordPress Database
  60. Connect a membership plugin to an external database
  61. Compare User meta_value with Product meta_value
  62. Storing user’s data on external database on other server
  63. is it right choose to connect database in template page directly in WordPress site?
  64. How to insert a value to decimal type field using wpdb->prepare?
  65. Sql query to get all metadata for a post
  66. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  67. Set a cron job to delete a specific database table table every midnight
  68. Two separate wordpress installations at one domain
  69. Is there a way to edit the WP content database in an admin panel or external page?
  70. Where do I put my create_new_table function()?
  71. SQL database import #1046 error
  72. Get all top categories, then only 3 posts for each
  73. Having all “non-PHP” files on a different server
  74. syntax error for changing user role from database
  75. Finding a page holding a specific string/URL that is used in the content
  76. “wordpress error in establishing database connection” and missing tables
  77. get_option() does unserialize and don’t remove \
  78. next comment id number wordpress
  79. Adding last value from Database as text in WordPress Page
  80. Want to update value in database. But it says update() on null
  81. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  82. How can I get $wpdb to show MySQL warnings?
  83. About wp database hooks (error establishing connection)
  84. Database for JQuery Autocomplete field
  85. Create Tables in WordPress
  86. Catchable fatal error in formatting.php
  87. Wrong url for the images while using same database for two WordPress installations
  88. WordPress Failed to Login (DB Error)
  89. Sending WordPress database information to cross domain the safe way?
  90. Database Name Change
  91. Share WordPress Database
  92. Where To Find bb_profile_data(); In bbPress?
  93. DB access blocked when initializing WP externally
  94. Site does not work right, pages not showing up, even for root admin
  95. ERROR: “Table Prefix” must not be empty
  96. How do you build a database-centric site in WP?
  97. WordPress: Interact with Database Query Data and Login
  98. Attach posts based on category and position
  99. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  100. WordPress database connection failed, while mysql client is working [closed]