エントリーナンバーが4桁になる前に
2月 18th, 2007
そろそろ本気でwordpressに移行をと思いつつなかなか。
SELECT inumber AS ID, iauthor AS post_author, itime AS post_date, DATE_SUB(itime, INTERVAL -9 HOUR) AS post_date_gmt, CASE iclosed WHEN 0 THEN "open" ELSE "closed" END AS comment_status, CASE idraft WHEN 0 THEN "publish" ELSE "draft" END AS post_status, CASE WHEN LENGTH(imore) = 0 THEN ibody ELSE CONCAT(ibody, "\n\n\n\n", imore) END AS post_content, ititle AS post_title, icat AS post_category, itime AS post_modified_date, DATE_SUB(itime, INTERVAL -9 HOUR) AS post_modified_gmt FROM nucleus_item
こんな変換でいいかな。
