I’ve been attempting to make sense of why the heck WordPress doesn’t export pages in their fancy plugin. But they don’t so I figured this craziness out. It actually worked for what I wanted it to do. This probably won’t help anyone but it helped me learning something new and overcome an ever present challenge.

SELECT *
FROM `wp_posts`
WHERE `post_type` = CONVERT( _utf8 ‘page’
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s