Create views in wordpress

We can separate the posts into different views

CREATE VIEW dictionary AS
SELECT ID, post_title as term, post_content as content, post_excerpt, post_status, LEFT(post_title , 1) as first_letter
FROM wp_posts
WHERE post_type like 'dictionary' and post_status like 'publish';

Popular posts from this blog

What are EAR, JAR and WAR files in J2EE?

[Solved] Hive installation error: Relative path in absolute URI

ATG Issue - ConcurrentUpdateException - on BCC Deployment