WPDB update row with != in where clause

Here is exmaple code,You will change as per your requirement

$wpdb->query(
    "
    UPDATE $wpdb->posts 
    SET post_parent = 7
    WHERE ID = 15 
        AND post_status="static"
    "
);

Related Posts:

  1. How to use $wpdb to delete in a custom table
  2. get_results on large datasets
  3. Is there a (better) way to access $wpdb results?
  4. Using $wpdb generates DB error
  5. How do you use prepare when asking for a list of id’s
  6. how to execute different sql query in non-sanitized $wpdb->get_results function
  7. How to update records using $wpdb?
  8. Need help writing a $wpdb query
  9. show badge with count for pending items in custom post type
  10. WP Sql query multiple where clause
  11. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  12. Modify the structure of data returned by $wpdb
  13. Syntax for $wpdb->prepare when searching in two columns
  14. Confused by $wpdb->prepare
  15. How to display user_nicename and usermeta values by custom query in WordPress?
  16. Optimizing WordPress Queries – Removing Group By ID
  17. How can I combine one field using wpdb and group by?
  18. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  19. how to use $wpdb->prepare to update a custom table
  20. WPDB Placeholders and second argument for prepared statements
  21. Increment integer field in database when WHERE needs to be dynamic [closed]
  22. Custom SQL query ORDER BY term_order
  23. Custom $wpdb returns unexpected time based results
  24. How to left join meta in queries [closed]
  25. wpdb->get_row is selecting the variable as a column name
  26. CREATE TABLE with dbDelta does not create table
  27. $wpdb query outputs php code instead of executing it
  28. wpdb query not working
  29. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  30. WPDB SQL Ignore `post_status` Parameter
  31. how to list all post that are in the custom taxonomy using $wpdb
  32. WPDB SQL query SELECT from category
  33. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  34. Creating an Angular factory from custom database table
  35. wpdb->update update the entire table instead of one row
  36. How do I update post based on meta_key in another table?
  37. How to set up prepared query using IN statement
  38. Custom database query to validate data
  39. Alter the main search query to search posts by coauthor user name
  40. Creates only one table and not the other
  41. Protect custom form from SQL injection
  42. looking for a way to allow users to backup the plugin db data(save as)
  43. SQL Query to select post title & post ID from a particular category
  44. Get comments after specific date
  45. query using wpdb in wordpress gets me no result
  46. Get count of rows based if column exists in two different tables
  47. query_vars doesn’t return query string (trying to get data from $wpdb)
  48. WPDB Insert or if exists Update
  49. How do I check for a duplicate record before inserting using wpdb
  50. WPDB prepare – like % – placeholders?
  51. Avoiding “Usage of a direct database call is discouraged”
  52. passing variables as parameters to stored procedures via wpdb from php-script
  53. $wpdb->query() multiple query support
  54. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  55. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  56. How to email user after inserting the username in database in WordPress
  57. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  58. How to fetch an array in $wpdb?
  59. What’s wrong with my $wpdb prepare?
  60. $wpdb select date range of posts
  61. Rolling Back from current WordPress version to previous one
  62. SQL query for custom taxonomy slugs
  63. Display fields as values in array from external SQL DB
  64. What is wrong with this wpdb update?
  65. using $wpdb to insert a form into a post
  66. wp_create_user not properly entering password
  67. Problem with creating tables for Plugin
  68. Foreach loop not working as expected – custom tables and references while submitting a form
  69. Query insert query executing multiple times
  70. Undefined offset: 0
  71. Connect to separate database using $wpdb and authenticate user
  72. How to access PostgreSQL using WPDB?
  73. Counting posts with argument without retrieving the posts
  74. how to assign content to a different author while loading content
  75. How to pass orderby params to $wpdb->prepare()?
  76. Register custom table for WP to use in a plugin
  77. Use $wpdb or other PHP script method to find/replace in WP database
  78. How to get INSERT errors from $wpdb?
  79. Display category names on edit user profile using $wpdb
  80. wpdb and acf via wp rest api
  81. wpquery properties last_query and last_result : should these be public or private?
  82. wpdb prepare sql problem
  83. Query and get meta as object(stdClass) on wp postmeta table?
  84. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  85. SQL queries to another wordpress site
  86. og:image functions.php
  87. Show error messages to a user when database insert fails
  88. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  89. Combine posts and postmeta
  90. WPDB delivers wrong results from complex queries
  91. Include post_status check within $wpdb query
  92. wpdb get_row database query inquiry
  93. Depreciated Call -> Function wpdb::escape()
  94. Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
  95. Retrieve a list of users based on some conditions
  96. wp-postratings: list current user’s unrated posts
  97. Error inserting row into table
  98. get only 1 wpdb and get taxonomy, post to next page [closed]
  99. $wpdb The query does not contain the correct number of placeholders
  100. $wpdb:insert, more arguements in $format array than in $data