CASE文(division系) - nkc-bakusi/music-site GitHub Wiki

CASE WHEN bpm BETWEEN 0 AND 50 THEN 1 WHEN bpm BETWEEN 50 AND 100 THEN 2 WHEN bpm > 100 THEN 3 END AS bpm_division,

こんな感じのをSELECT句に追加

---

データベースにある全てのbpm値　 79 82 91 102 106 108 116 135 140 157 165 合計11件

bpm 120前後5件を表示した場合 bpm 差分 102 -18 106 -14 108 -12 116 -4 135 -15

bpm 116のSQL文 SELECT * FROM music WHERE abs(bpm-120)= (SELECT MIN(abs(bpm-120)) FROM music WHERE bpm <120)

bpm 135のSQL文 SELECT * FROM music WHERE abs(bpm-120)= (SELECT MIN(abs(bpm-120)) FROM music WHERE bpm>120)