Adding featured for post using database

First of all, never ever use Plain SQL query to WordPress, because it’s too dangerous. Try $wpdb class, if you need to.

BTW, adding posts, post description, assigning featured image, etc. there are wrapper functions designated for these particular tasks, like:

Always, try to consult Codex or Developer Guide for true direction.

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. How can I make a WordPress database portable and url independent?
  7. Database connection close
  8. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  9. How to create bulk page and content? [closed]
  10. Importing posts from old website to new conflicting post ID’s?
  11. Exporting revisions
  12. WP_Options ID high
  13. Default WordPress settings API data sanitization
  14. The revisions table in my database is at 70% capacity and growing. What should I do?
  15. WordPress for a very large website
  16. How to use multiple database in wordpress?
  17. WP_list_table bulk_action get edit and delete
  18. Is removing orphaned wp_postmeta records safe?
  19. How to intercept update_option() before it saves data?
  20. wpdb query on custom table not working [closed]
  21. stdObject stored in database. How does one convert it to usable format?
  22. What ALL can cause “Another update is currently in progress.”? [closed]
  23. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  24. Set Display Name to first and last name (phpmyadmin SQL Query)
  25. How to fix unchanged URLs in Database after running serialized search and replace script?
  26. Trigger Plugin database update after git pull
  27. Does WordPress ever need multiple databases?
  28. Why are no posts showing despite my apparently correct DB restoration?
  29. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  30. Cannot update custom database table row
  31. SQL Error wp_commentmeta – incorrect table definition
  32. WordPress database error – Error in SQL syntax – I can’t identify any error?
  33. Change WordPress prefix for only one table?
  34. Two websites one database, administrator not working on second website
  35. Select two sums with single get_var statement
  36. How to get the SQL of the changes made to the database from an update or upgrade?
  37. Merging two wp_posts tables while avoiding duplicates
  38. How can i add custom fields into the contact form 7 [closed]
  39. Make an Items attribute searchable (taxonomy using existing attribute)
  40. Store partial database to an archive database time to time
  41. Move out of sync posts from one database to another
  42. MS Access to manage WordPress Database
  43. Migration: Copying database content to a different server
  44. Remove empty rows from the database
  45. Custom WordPress Table wpdb
  46. Check if post id exist in table than only update instead of inserting new row
  47. Detail explanation of wordpress database fields and metatag list [closed]
  48. CreateOrUpdate in WordPress
  49. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  50. How to convert srcset links from https to http?
  51. How to get a list of WordPress default database tables?
  52. Can local WordPress installs share /wp-content/ folder and database?
  53. how to encyrpt DB_PASSWORD in wp-config
  54. Choosing http or https during manual installation of WordPress and database
  55. Stringing together content from different databases
  56. Backing up WordPress database and files
  57. Safely store code(html/js..) into database
  58. Why does wp_links still exist in the db schema?
  59. Creating and Using Tables in the WordPress Database
  60. can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
  61. Connect a membership plugin to an external database
  62. Compare User meta_value with Product meta_value
  63. Storing user’s data on external database on other server
  64. is it right choose to connect database in template page directly in WordPress site?
  65. How to insert a value to decimal type field using wpdb->prepare?
  66. Sql query to get all metadata for a post
  67. Is there a way to edit the WP content database in an admin panel or external page?
  68. Where do I put my create_new_table function()?
  69. Is there any defects for using same database prefix in WordPress for multiple sites?
  70. SQL database import #1046 error
  71. How to import products in host instead of database on wordpress?
  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. Counting user’s comments – efficient way?
  82. Merging development site with live site
  83. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  84. Backup Restore turns carriage returns to literal strings
  85. I have a WordPress 4.6 database dump – how do I use it in a new install?
  86. Should I Use only wpdb Class to Write Custom Queries?
  87. Create Tables in WordPress
  88. Catchable fatal error in formatting.php
  89. Wrong url for the images while using same database for two WordPress installations
  90. WordPress Failed to Login (DB Error)
  91. Sending WordPress database information to cross domain the safe way?
  92. Database Name Change
  93. Weird characters in title if it contain “ ”
  94. Share WordPress Database
  95. Where To Find bb_profile_data(); In bbPress?
  96. ERROR: “Table Prefix” must not be empty
  97. How do you build a database-centric site in WP?
  98. Attach posts based on category and position
  99. WP Multisite Users Not Linking
  100. Query a meta key using an array of values where the database value is a string
error code: 523