post-meta

Retrieve posts from meta key

To use the LIKE comparison, try a string: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘meta_query’ => array( array( ‘key’ => $user_key, ‘value’ => ‘followed’, // String here ‘compare’ => ‘LIKE’, ), ), ); return get_posts($args); Also, you can use WP_Query to help you debug: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => … Read more

How to sort by meta value num, but ignore zero value?

You can use a meta_query in your WP_Query $args = array( ‘post_type’ => ‘company’, ‘meta_query’ => array( array( ‘key’ => ‘service_XXXX_price’, ‘value’ => ‘0’, ‘compare’ => ‘!=’, ), ), ); $company_query = new WP_Query( $args ); You can find more infos about the meta querys in the codex: https://codex.wordpress.org/Class_Reference/WP_Query

Exclude category from DB query

I’m sure there’s a better approach, but this query should do what you want: SELECT DISTINCT meta_value FROM wp_postmeta pm WHERE meta_key = ‘Driver’ AND NOT EXISTS (SELECT * FROM wp_term_relationships tr JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id JOIN wp_terms t ON t.term_id = tt.term_id WHERE pm.post_id = tr.object_id AND tt.taxonomy = ‘category’ AND … Read more

Restore deleted _thumbnail_id in postmeta table

I figured it out. Somehow in the import process a trailing space was added to the meta_key (making it “_thumbnail_id “). Mysql apparently matches on a trailing space which is why it wasn’t apparent, but once I removed the space all featured images started showing again.

How Can I extract Image urls from post meta

Get the post meta unserialized (WordPress does this for you): $data = get_post_meta( $post_id, ‘name_of_field’, true ); Use a regular expression: if ( preg_match_all( ‘!https?://[^” ]+!’, $data, $matches ) ) print_r( $matches[0] );

+ More