How do I get posts where image is larger than…?

There is no clean way to do this. Each image stores image information in post meta table, but as a part of the serialized PHP string.

  1. Using MySQL for that is out of the question because MySQL doesn’t have a syntax for extracting regular expressions matched content, it can only use perform true/false/like expressions using regular expressions.

  2. The only other solution is PHP looping through all posts, loading featured image and comparing sizes. Depending on the number of posts with featured images you have, this might very slow and time-consuming, especially if you need to run it in the real time.

Related Posts:

  1. How to get_posts having post thumbnail?
  2. Recent posts on homepage: different thumbnail based on logged in status and post category
  3. Add class name to post thumbnail
  4. Delete original image – keep thumbnail?
  5. the_post_thumbnail responsive srcset not populating with custom image size
  6. Set custom name for generated thumbnails
  7. How to add multiple image sizes of the same size with add_image_size
  8. change set_post_thumbnail_size according to post type admin page
  9. Can’t extract and set SVG dimensions
  10. Getting Thumbnail Path rather than Image Tag
  11. How to crop thumbnail height to auto with set width
  12. Use thumbnail image using url of that image
  13. Image uploader with “Set Featured Image” link on front end
  14. adding an id to the_post_thumbnail
  15. How can I display my featured image correctly inside my single posts?
  16. Featured image upload finished hook
  17. Generate thumbnail for images with the same size as thumbnails
  18. Implementing Zurb’s Interchange Into WordPress
  19. Display the first image from a post in RSS feed
  20. Filter For Featured Image
  21. add_image_size and add_filter(‘image_size_names_choose’, ‘my_custom_image_sizes’) not working with wordpress 3.5.2
  22. Custom post type thumbnail / Media Library WP_DEBUG notice [closed]
  23. Add body class based on existance of post thumbnail. Code works but receiving PHP Notice
  24. Delete all thumbnails for a post
  25. How to display thumbnail + tags + title of a child page?
  26. Archive Thumbnail Gallery
  27. How to delete posts that does not have a thumbnail?
  28. WordPress Uploader Editor shows broken image
  29. How do i show wordpress attachments from current post?
  30. How to get full absolute url for post attachment?
  31. Can’t get image size set with set_post_thumbnail_size() function
  32. How to check the array of featured images IDs
  33. Show LightBox when clicking on featured image [closed]
  34. Get ID of featured image using “get_post_thumbnail_id(the_ID())” – without printing to screen?
  35. what is the difference between timthumb and post thumbnail?
  36. Duplicated featured image is not showing
  37. Create thumbnail size only for a few images?
  38. How to find post with broken image link and delete that post
  39. show first 3 thumbnails of posts in different sizes [closed]
  40. Else condition not working while using has_post_thumbnail
  41. Only Display Thumbnail if Larger Than
  42. WP Query to set post thumbnail for existing old posts
  43. get_post_thumbnail_id() Doesn’t return value [closed]
  44. Why is the post title and content automatically being displayed in the post thumbnail (Featured image)?
  45. Video playing from featured image?
  46. How to deal with wordpress images?
  47. Disable post thumbnails in Twenty Thirteen child theme
  48. How can I find the first post in a category that has a featured image and then return the get_the_post_thumbnail()?
  49. Post thumbnail throwing size limit parameters in
  50. How do I add a default thumbnail to elseif when no get_field(‘photos’), and no post thumbnail exists?
  51. Problem with showing featured image
  52. Getting img src from thumbnail_id using javascript
  53. Easy way to update a single translation entry without having to translate
  54. If the_post_thumbnail(); is this – echo this text
  55. get_post_thumbnail does not display thumbnail
  56. Make image full width
  57. Facebook Does Not Grab Correct og:Image
  58. WordPress 4.4 responsive sometimes doesn’t work
  59. get_the_post_thumbnail($post->ID, ‘thumbnail’); not working. How can I solve this?
  60. Is it possible to add the_post_thumbnail to style.css?
  61. Getting featured image of particular size.
  62. Different thumbnails for index and article page
  63. Smaller thumbnail in the_content
  64. Get post featured image id with $wpdb
  65. Attachment Image using wrong src?
  66. Create an instance of add_image_size
  67. Unable to set Custom “Link URL” for Featured Image, and More?
  68. On what point (hook) does the_/has_post_thumbnail() load?
  69. First Image not loading on Mobile Version of Website
  70. Thumbnails not being generated for PDF files
  71. Make 1st Slide of PowerPoint file to be the Post thumbnail preview image
  72. Is it possible to set Featured Image using HTML?
  73. Smush Featured image constraining in image file that is being loaded on page
  74. Set featured image from auto generated video thumbnail url php
  75. Use Post Title as alt text for Featured Image
  76. How to cropped thumbnail image without distorting it?
  77. WordPress default srcset with hard crop
  78. wp_get_attachment_metadata()[‘image_meta’] fetch WP metadata or EXIF?
  79. White Blank screen and issue to get thumbnail in
  80. Adding a class to certain featured images
  81. Set Featured Image Based on Custom Field
  82. Post thumbnail on specific template
  83. Using lower resolution/size images for thumbnails on posts index
  84. WordPress auto picking featured image
  85. How to have featured image show in standard RSS Widget
  86. Link from Thumbnail to Post not working
  87. Featured Image metabox (postimagediv) doesn’t appears when it should
  88. Thumbnails not showing in blog
  89. Featured Image inserted through custom query, does not show up
  90. How to import linked images and make them featured -> automagically
  91. Change role’s settings influence post-thumbnail
  92. Wrap Featured Image in a Link
  93. Thumbnail images
  94. Featured Image Thumbnail Sizing
  95. Featured Image Isn’t showing with cropped, How to show it?
  96. How to modify Media Library images DPI [ image quality down to make small in size ] [closed]
  97. How to add text & call to action button to featured image on homepage?
  98. Featured image as background in a div using headway
  99. php code for image fetching
  100. Hot to change resized image link on posts