Tagged Questions
0
votes
1answer
34 views
SQL Bulk Move old posts by one author to another category
I'm looking to move a number of old posts by one author from one category to another category and was hoping someone could help me do this?
I figure the easiest way would be through an SQL command?
...
0
votes
0answers
56 views
Special Query: Title, Terms, Content - %LIKE%
I'm working on a them theme that is search-heavy, and my users are putting huge priority on an improved search function.
I think I will have to use a special direct query to search these things:
...
4
votes
1answer
512 views
Export WordPress Posts and Meta Information in CSV format
I need to export all WordPress Posts and related Meta information using an SQL query. I've managed to export just the Posts but realised that the Meta information is in another table.
Could someone ...
0
votes
1answer
151 views
Export all posts to import as product items
Up until now, my client has been using WordPress posts as his way to display his products. I now need to export all these posts into a CSV format so that I can format the CSV file and import it back ...
2
votes
1answer
93 views
Sql syntax error
Sometimes in my error log i have this error:
You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to
use near '' at line 1
...
0
votes
1answer
73 views
How can I get posts from 9/13/11 to today with SQL? [closed]
I have been working with a client to redesign his site and we are at the stage where we are going live, except I'm running into a little problem. Time is of the essence, as the deadline is mid-day ...
0
votes
2answers
1k views
SQL query to extract only the “current” wp_posts?
The wp_posts table seems to retain all revisions of the same, ok very similar but presumably different, posts/pages/whatever.
I'm somewhat conversant with SQL but not WordPress. I need to extract ...
0
votes
1answer
146 views
How to export 2 week's worth of posts
I need to export the last two week's worth of blog posts from one site into another site, including all meta data and post author info.
Is there a good SQL statement to do this, or a plugin that ...
2
votes
1answer
361 views
get posts and postmetas in assoc array
how do I get all posts and postmetas in an associative array?
$allposts = $wpdb->get_results("
SELECT $wpdb->posts.post_title, $wpdb->postmeta.meta_key
FROM $wpdb->posts
JOIN ...
2
votes
2answers
466 views
Use Cron to modify posts via sql
Hi to all I need to run this twice a day:
UPDATE wp_posts SET post_content = REPLACE ( post_content, '[img]', '<img src="' );
UPDATE wp_posts SET post_content = REPLACE ( post_content, '[IMG]', ...
0
votes
1answer
590 views
Troubles about insering a POST with a SQL query, post_status
I 'm using wordpress 3.0.5
I have to use sql for create post, here is my SQL query:
$req = $bdd->prepare('INSERT INTO wp_posts ...
2
votes
2answers
1k views
Alter query on edit.php
What's the best way to alter the query being run on the Posts Edit screen (edit.php)?
The current method I'm using is by passing an argument to the global $wp_query like so:
$wp_query->query( ...
