mysql> select * FROM halilar WHERE Yoresi LIKE 'C_cim' ORDER BY FiyatUSD DESC LIMIT 0,5; +-----+---------+----------+----------------+------------+--------------+--------+--------+------------+--------+----------+----------+------+ | hID | BoyutEn | BoyutBoy | Aciklama | AciklamaEN | DepoNumarasi | Yoresi | Sinifi | Kategorisi | Durumu | FiyatYTL | FiyatUSD | Adet | +-----+---------+----------+----------------+------------+--------------+--------+--------+------------+--------+----------+----------+------+ | 421 | 156 | 235 | Eski(Old)cicim | | 939-pk | Cicim | K | R | | 1402.5 | 1292.5 | 1 | | 420 | 158 | 213 | Eski(Old)Cicim | | 1016-pk | Cicim | K | R | | 1265 | 1072.5 | 1 | | 419 | 180 | 220 | Eski(Old)Cicim | | 933-pk | Cicim | K | R | | 1017.5 | 962.5 | 1 | | 418 | 137 | 228 | Eski(Old)Cicim | | 364-pk | Cicim | K | R | | 962.5 | 852.5 | 1 | | 417 | 150 | 216 | Eski(Old)Cicim | | 960-pk | Cicim | K | R | | 852.5 | 742.5 | 1 | +-----+---------+----------+----------------+------------+--------------+--------+--------+------------+--------+----------+----------+------+ 5 rows in set (0.00 sec)