Export SQL query based on custom field?

Change your query to:

SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_ID = wp_posts.ID WHERE ( wp_postmeta.meta_key = 'Color' AND wp_postmeta.meta_value IS NOT NULL );

That way it only gets the data in wp_posts, but still filters based on your criteria.

Related Posts:

  1. Unknown collation when I import a dump from an existing site into a development database?
  2. Exporting completed webiste for another server
  3. How do I import an SQL file using the command line in MySQL?
  4. Setting up foreign keys in phpMyAdmin?
  5. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  6. MySQL Error #1133 – Can’t find any matching row in the user table
  7. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  8. How to create a foreign key in phpmyadmin
  9. importing a CSV into phpmyadmin
  10. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  11. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  12. What specific database privileges does WordPress need?
  13. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  14. How to copy post titles to post slug in phpmyadmin
  15. Export only pages and posts with mysql dump
  16. How to do a MySQL dump from production site without using a search and replace script for local development?
  17. MySQL Syntax Error upon restoring database from backup [closed]
  18. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  19. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  20. Error while importing database
  21. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  22. Can’t find my wordpress DB in phpmyadmin
  23. WordPress database import: Row size too large
  24. Backing up and restoring multiple sites efficiently
  25. $wpdb to insert html form information
  26. Create a form with custom autocomplete address field and CSV import values
  27. Setting up WordPress Locally on WAMP for a new site (with one already)
  28. Getting Error Trying to Create Table
  29. Export Yoast Keywords from MySQL/phpMyAdmin
  30. Editing mysql tables/database with wordpress or other app/cms
  31. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  32. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  33. List users with the most posts in the last 30 days
  34. latency problems with wordpress install (from SQL import)
  35. Mysql Server keeps crashing
  36. How to bulk delete a certain part of all wordpress posts
  37. When I add metadata, metavalue length is added in to the value in some cases
  38. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  39. Find locations of all featured images of draft posts via SQL
  40. SQL query to change custom field in WordPress database
  41. An SQL query to find orphaned image attachments and their meta
  42. Weird characters displayed when importing WordPress MySQL db
  43. Export posts with postmeta without ID?
  44. cannot log in to the mysql server (wamp and wordpress)
  45. SQL command to export post_content from wp_posts using phpMyAdmin
  46. Need SQL query to find&replace image URL
  47. How do I load a sql.gz file to my database? (importing)
  48. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  49. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  50. MySQL ERROR 1290 (HY000) –secure-file-priv option
  51. mysql Foreign key constraint is incorrectly formed error
  52. mysql: SOURCE error 2?
  53. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  54. MySQL IF NOT NULL, then display 1, else display 0
  55. Repair all tables in one go
  56. Failed building wheel for mysql-python
  57. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  58. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  59. Remove Primary Key in MySQL
  60. mysql: connection refused when trying to connect to localhost using remote IP
  61. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  62. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  63. Complex meta query with 3 keys
  64. Gaining Login Access via the Database
  65. query to create woocommerce products from images
  66. Configure WordPress to connect to Mysql DB using SSH tunneling
  67. wordpress custom theme import and export options for sample data [closed]
  68. Is it possible to recover featured images after WordPress export/import
  69. Imported thumbnails have incorrect URL
  70. Moving test theme to live site without mySQL error – how? [closed]
  71. How to split the a table in database?
  72. How do I join a $wpdb query with user meta using default value if not exist?
  73. mySQL statment count of post in each category and sub category
  74. WordPress Local And Live Site
  75. Paypal Post IPN handeling nightmare
  76. Moving WordPress site to an existing WordPress site
  77. WordPress tables and aliases?
  78. What’s the sql for this condition?
  79. WordPress insert query is not working : Showing no Error
  80. Copy usermeta value where ID matches in the same table
  81. Some Post Content Does Not Show Up In DB Search
  82. Plugin generating unexpected output – on WP mysql dump import
  83. Exporting by table
  84. Upgrade DB Loop – WordPress DB Version Conflict
  85. Two-way synchronizing of a post type among multisite blogs
  86. Transferring theme and imported post attachments
  87. Button writing to MYSQL database
  88. MySQL ‘duplicate entry’ error
  89. How to show result of sql query in a page?
  90. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  91. How to import several big Import XMLs?
  92. Query does not filter duplicate _sku numbers
  93. MySQL Select within WP Page template
  94. wp_postmeta – lot of meta fields
  95. Delete posts with word count less than x number of words
  96. MySQL: get post_tag items that are tags (not SEO keywords)
  97. $wpdb->get_var returns 0
  98. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  99. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  100. Batch Replace URLs in WordPress Database