title: Wordpress add custom column
body: <p>I need to add a column to the WordPress posts table. The column will contain numeric values so that I can make very simple queries with rows ordered by that field. By now the values are saved as post meta but I need to have them in the post table so that I can order the posts by that field.</p>
  
  <p>I know that I could just call the query on the post_meta table and order the rows by the value, then get the post through the post_ID. However, this way anytime I do a search, the posts with the same value wouldn't be ordered alphabetically but only by post_meta_ID.</p>
  
  <p>So my question is: if I add a column to the wp_posts table, will it be removed/edited on the next WordPress update? There's a way to make it permanent or to update it with Wordpress?</p>