SELECT wb.*, sort_order.seq FROM wiz_book wb JOIN ( SELECT 'Reading Bike' AS book_name, 1 AS seq UNION ALL SELECT 'Reading Boat', 2 UNION ALL SELECT 'Reading Kite', 3 UNION ALL SELECT 'Reading Train', 4 UNION ALL SELECT 'Reading Jet', 5 UNION ALL SELECT 'Reading Rocket', 6 UNION ALL SELECT 'Reading Town', 7 UNION ALL SELECT 'Reading World', 8 UNION ALL SELECT 'Reading Planet', 9 ) AS sort_order ON CONVERT(SUBSTRING_INDEX(wb.book_name, ' ', 2) USING utf8) = CONVERT(SUBSTRING_INDEX(sort_order.book_name, ' ', 2) USING utf8) WHERE wb.gu_id = '012007' ORDER BY sort_order.seq, wb.book_id;

서브메뉴 바로가기 본문 바로가기 하단메뉴 바로가기