Ornagai SQL
လက္ရိွ Ornagai မွာ သံုးထားတဲ့ MySQL query ပါ။
SELECT * , IF( `Word` = 'sim', 1, IF( `Word` LIKE 'sim%', 2, IF( `Word` LIKE '%sim', 4, 3 ) ) ) AS `sort` FROM `dblist` WHERE `Word` LIKE '%sim%' ORDER BY `sort` , `Word`Sqlite မွာဆိုရင္ေတာ့
SELECT *, CASE WHEN `Word` = 'sim' THEN 1 WHEN `Word` LIKE 'sim%' THEN 2 WHEN `Word` LIKE '%sim' THEN 4 ELSE 3 END `sort` FROM `dblist` WHERE `Word` LIKE '%sim%' ORDER BY `sort` , `Word`
