How would I go about truncating a field such as the excerpt? I am using the following:
SELECT ID,post_title,post_name,post_date,post_status,post_content,post_excerpt, LEFT(post_excerpt, 20) FROM wp_posts WHERE (post_type='post') AND (post_status='publish') AND (post_date BETWEEN '2012-08-01' AND '2012-08-31')
The LEFT obviously will not work for the fields or the export. Is there a way to limit the characters on this field in the filter functions? Some help on how to do this would be awesome!