Export SQL query based on post type

In your WordPress Dashboard, if you go to Tools > Export, you can select your custom post type and export only posts in that post type.

It gives you the option between All Content, Posts, Pages, and your custom post types following those three options.

As for SQL, well are you looking to export the data from something like phpMyAdmin? You could use this:

SELECT * 
FROM  `wp_posts` 
WHERE  `post_type` =  "post type name here"

Hope this helps.

Also, as kaiser pointed out in a comment, you may need to deactivate all plugins and switch to the default theme.

Related Posts:

  1. How to export 2 week’s worth of posts
  2. What’s the best way to search for a UPC code in a Database?
  3. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  4. Case in Select Statement
  5. Self Join to get employee manager name
  6. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  7. Online SQL Query Syntax Checker
  8. How can I do an UPDATE statement with JOIN in SQL Server?
  9. How do I use properly CASE..WHEN in MySQL
  10. Must declare the scalar variable
  11. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  12. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  13. SQL SELECT WHERE field contains words
  14. Case statement in MySQL
  15. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  16. Drop a temporary table if it exists
  17. ORA-00918: column ambiguously defined in SELECT *
  18. IDENTITY_INSERT is set to OFF – How to turn it ON?
  19. How to reset AUTO_INCREMENT in MySQL
  20. How do I limit the number of rows returned by an Oracle query after ordering?
  21. MySQL: Invalid use of group function
  22. Compare dates in MySQL
  23. Best way to do nested case statement logic in SQL Server
  24. Difference between one-to-many and many-to-one relationship
  25. Get day of week in SQL Server 2005/2008
  26. incorrect syntax error CREATE VIEW must be the only statement in the batch
  27. PLS-00103: Encountered the symbol when expecting one of the following:
  28. How do I format date and time on ssrs report?
  29. missing FROM-clause entry for table
  30. MySQL Error 1264: out of range value for column
  31. How to parse XML data in SQL server table
  32. How do you create a temporary table in an Oracle database?
  33. Oracle SQL: Update a table with data from another table
  34. How to SUM and SUBTRACT using SQL?
  35. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  36. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  37. Postgresql tables exists, but getting “relation does not exist” when querying
  38. Sql query to insert datetime in SQL Server
  39. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  40. SQL selecting rows by most recent date with two unique columns
  41. Postgres Error: More than one row returned by a subquery used as an expression
  42. Comparing Dates in Oracle SQL
  43. How to divide two columns?
  44. MySQL starts with searching issue
  45. SQL Parentheses use in an OR clause
  46. Is it possible to GROUP BY multiple columns using MySQL?
  47. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  48. SQL “select where not in subquery” returns no results
  49. ListAGG in SQLSERVER
  50. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  51. Best way to test if a row exists in a MySQL table
  52. Get current year in TSQL
  53. Is it possible to specify condition in Count()?
  54. SQL Server: Make all UPPER case to Proper Case/Title Case
  55. using sql count in a case statement
  56. How do I query for all dates greater than a certain date in SQL Server?
  57. Temporary table in SQL server causing ‘ There is already an object named’ error
  58. Oracle: If Table Exists
  59. Equivalent of explode() to work with strings in MySQL
  60. How to calculate age (in years) based on Date of Birth and getDate()
  61. How to create id with AUTO_INCREMENT on Oracle?
  62. MySQL OPTIMIZE all tables?
  63. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  64. How do I count unique items in field in Access query?
  65. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  66. Append table to an existing one: SQL Server
  67. How to order by column A and then by column B?
  68. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  69. Update query using Subquery in Sql Server
  70. What is a postgres superuser
  71. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  72. prepare() not working
  73. How do I move a WordPress site to another server?
  74. Return number of items in a table with post id
  75. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  76. Auto-update tables from database
  77. Debugging WordPress
  78. dbDelta not creating table (yes, once more)
  79. Convert a category of posts to a custom post type using (MySQL) queries
  80. I need a SQL command to delete specific authors and all posts connected with them
  81. Connect to Ms SQL Server
  82. How can i restore only Blogs from a SQL backup file?
  83. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  84. wpdb prepare sql problem
  85. Exporting by table
  86. Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
  87. REGEXP_REPLACE in post_contet
  88. How to change post published date to today date with SQL
  89. Menu Order updating automatically
  90. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  91. How delete post_content records of specific category from phpmyadmin
  92. how to SELECT meta values that are not null?
  93. Fastest way to display 5000 post titles?
  94. How do I display SQL query on a specific page of my wordpress site
  95. Is it possible to utilize custom SQL for a single-post.php?
  96. blank page after update my theme
  97. Sql query returns empty. But not
  98. How can I avoid duplicate primary keys in SQL import?
  99. SQL – JOIN last child
  100. Adding profile data to database