SELECT sfo.*
FROM sales_flat_order sfo
WHERE sfo.increment_id = 'MY_ORDER_NUMBER';