Force new URL for WordPress blogs

Insert this into your wp-config.php file to force a new URL on a WordPress blog: Very useful for the initial move before being able to hop in to the database and correctly update everything.

Sort Select Results by Arbitrary Values

SELECT ColumnOne, ColumnTwo, ColumnThree FROM Table ORDER BY CASE ColumnTwo WHEN ‘miny’ 1 WHEN ‘meeny’ 2 WHEN ‘eeny’ 3 WHEN ‘moe’ 4 END, ColumnThree