目录 一、关系运算： ....................................................................................................................... 4 1. 等值比较: = .................................................................................................................. 4 2. 不等值比较: <> ............................................................................................................ 4 3. 小于比较: < .................................................................................................................. 4 4. 小于等于比较: <= ........................................................................................................ 4 5. 大于比较: > .................................................................................................................. 5 6. 大于等于比较: >= ........................................................................................................ 5 7. 空值判断: IS NULL ....................................................................................................... 5 8. 非空判断: IS NOT NULL................................................................................................ 6 9. LIKE 比较: LIKE .............................................................................................................. 6 10. JAVA 的 LIKE 操作: RLIKE ............................................................................................ 6 11. REGEXP 操作: REGEXP ................................................................................................ 7 二、数学运算： ....................................................................................................................... 7 1. 加法操作: + .................................................................................................................. 7 2. 减法操作: - .........................................................................................
