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

Home Sign Up Sign In

› MySQL 5.5 Community Server

› MySQL 5.6 Community Server

› Percona Configuration Wizard

› XtraBackup 搭建主从复制

Great Sites on MySQL

› MySQL Performance Blog

› Severalnines

推荐管理工具

推荐书目

› MySQL Cookbook

MySQL 相关项目

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 4958 days ago, the information mentioned may be changed or developed.

3 replies • 1970-01-01 08:00:00 +08:00

1

ljbha007

Mar 7, 2013

select * from my_table where id % 3 = 0

2

cjou

Mar 7, 2013

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

3

likexian

Mar 7, 2013

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

About · Help · Advertise · Blog · API · FAQ · Privacy · Solana · 926 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 25ms · UTC 17:56 · PVG 01:56 · LAX 10:56 · JFK 13:56
♥ Do have faith in what you're doing.