526互联

mysql同一张表不同字段的值比较

发布时间 2023-12-11 19:40:36作者: 羽*枫

比较两个字段值是否相等
SELECT * FROM table_a WHERE account = card_num;

比较两个字段值是否不等
SELECT * FROM table_a WHERE account != card_num;

比较两个字段值大小
SELECT * FROM table_a WHERE account > card_num; SELECT * FROM table_a WHERE account >= card_num; SELECT * FROM table_a WHERE account < card_num; SELECT * FROM table_a WHERE account <= card_num;