How to select meta fields in wordpress?

Question

MySQL

How to select meta fields in wordpress?
There is a meta field "close_date", you need to make a selection for those posts where the field "close_date" has any value.

Answer 1

$query = new WP_Query( array(
    'meta_query' => array(
        array(
      'key'     => 'close_date',
      'value'   => '',
      'compare' => '!=',
  ),
     )
) );

Try this

Answer 2

global $wpdb;
  
$qry = "select  t1.*
    from wp_posts t1
    inner join
    (
      select 
      post_id
      from wp_postmeta
      where meta_key = 'close_date' and meta_value = '2016-03-29' 
    ) t2 on t2.post_id = t1.ID";

$rows = $wpdb->get_results( $qry );

foreach( $rows as $row ) {
  ...
}

Answer 3

Check out this little post

Answer 4

The field stores the date