请问mysql如何查询id能被3整除的数据

[lusin]

[ljbha007]

select * from my_table where id % 3 = 0

[cjou]

SELECT id From `table` WHERE id mod 3=0;

[likexian]

http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_mod