select * from card where edy = 1 and mailageFlag = 1 and ABS(milagepointhiritu / mmoney) &lt;= 100 and abs(milagepointhiritu / mmoney) &gt;= 1 order by rank,reward,rday desc<br>エラーコード:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 100 and abs(milagepointhiritu / mmoney) &gt;= 1 order by rank,reward,rday desc' at line 1