Change sticky status of posts from phpMyAdmin

The sticky posts info is stored in the sticky_posts option in the options table.

It’s stored as serialized array e.g. a:2:{i:0;i:1272;i:1;i:1995;}

You can modify it via the Options API but there’s a way to bulk edit posts in the backend:

1. Select the Sticky view:

1

2. Select all sticky posts and apply the bulk Edit action:

2

3. Make them non-sticky:

3

and press update.

Related Posts:

  1. MySQL: Can’t create table (errno: 150)
  2. How to retrieve sticky post in raw sql?
  3. Moving database with phpMyAdmin
  4. Restose content from revisions – sql query
  5. Better way to migrate to server?
  6. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  7. How delete post_content records of specific category from phpmyadmin
  8. Reset post IDs with all post meta
  9. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. SQL WITH clause example [duplicate]
  12. The wait operation timed out. ASP
  13. Conversion failed when converting date and/or time from character string while inserting datetime
  14. how to fix oracle ORA-01722 invalid number error
  15. SQL query to select dates between two dates
  16. MySQL – Operand should contain 1 column(s)
  17. SQL SELECT WHERE field contains words
  18. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  19. NOT IN vs NOT EXISTS
  20. Must declare the scalar variable
  21. MySQL query String contains
  22. How do I escape a single quote in SQL Server?
  23. T-SQL split string based on delimiter
  24. Finding duplicate values in a SQL table
  25. MySQL Cannot Add Foreign Key Constraint
  26. mysql Foreign key constraint is incorrectly formed error
  27. Can a foreign key be NULL and/or duplicate?
  28. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  29. How do composite indexes work?
  30. Difference between JOIN and INNER JOIN
  31. MySQL “WITH” clause
  32. What is the difference between JOIN and UNION?
  33. MySQL Multiple Joins in one query?
  34. Error Code: 2013. Lost connection to MySQL server during query
  35. SQL join on multiple columns in same tables
  36. Sql query – getting rid of hard-coded values
  37. ORA-00918: column ambiguously defined in SELECT *
  38. Combining “LIKE” and “IN” for SQL Server
  39. How To Run A Github Repository?
  40. SQL Switch/Case in ‘where’ clause
  41. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  42. SQL Server WITH statement
  43. How to run a SQL query on an Excel table?
  44. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  45. Oracle “Partition By” Keyword
  46. What is the equivalent of ‘describe table’ in SQL Server?
  47. Add a column with a default value to an existing table in SQL Server
  48. Remote table-Valued Function Calls are not allowed
  49. The backend version is not supported to design database diagrams or tables
  50. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  51. Difference between View and table in sql
  52. Exclude a column using SELECT * [except columnA] FROM tableA?
  53. How do you force mysql LIKE to be case sensitive?
  54. What is the difference between a stored procedure and a view?
  55. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  56. pg_ctl: no database directory specified and environment variable PGDATA unset
  57. ERROR 1148: The used command is not allowed with this MySQL version
  58. Bulk load data conversion error (truncation)
  59. Difference between INNER JOIN and LEFT SEMI JOIN
  60. SQL conditional SELECT
  61. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  62. PostgreSQL create table if not exists
  63. PostgreSQL visual interface similar to phpMyAdmin?
  64. Solutions for INSERT OR UPDATE on SQL Server
  65. GROUP BY and COUNT using ActiveRecord
  66. MySQL – Get row number on select
  67. MySQL error: Unknown column in ‘where clause’
  68. What is the difference between Views and Materialized Views in Oracle?
  69. How to truncate the text returned for a column in a MySQL query
  70. “select * into table” Will it work for inserting data into existing table
  71. ORA-01735: invalid ALTER TABLE option – Toad
  72. CASE IN statement with multiple values
  73. List of special characters for SQL LIKE clause
  74. Why doesn’t wp_update_post() update the post_status field?
  75. Use wpdb->prepare for `order by` column name
  76. How To Write An Inner Join With WP Query
  77. Cron While Editing Post
  78. Update user_login, user_nicename, and display_name
  79. Best Way to Merge a Dev and Live Site to Become a Staging Site?
  80. How to import a Typo3 database to a wordpress site?
  81. How to change post status from “draft” to “publish”?
  82. What does the $posts_join filter join to?
  83. Clean up very big and very dirty database
  84. How to delete ALL comments from certain category in WordPress database?
  85. How can I convert everything from category X to have post format Link
  86. Bulk delete WordPress Post and all metadata, etc using SQL query
  87. Display data from phpMyAdmin with WordPress
  88. Update WooCommerce stock status with SQL query if stock value is greater than 0
  89. SQL query to change custom field in WordPress database
  90. update_post_meta not working in template_redirect action
  91. How to Add or Change Post Title
  92. Why does DROP TABLE-ing the `wp_options` reset my user session?
  93. How to refactor DB queries for better TTFB in WordPress?
  94. query sql-table and change entities
  95. Duplicate WP Migration affecting site on separate domain?
  96. Analog category_and (WP) in sql query
  97. Backtick (MySQL norm) added to SQL Server Query causing error
  98. WordPress character set issue
  99. SQL query to check whether a meta key is set or not for a post in post_meta table
  100. Deleting the MySQL database