mysql查询或更新单双数字的内容

select * from tbl_name where userid%2=1


mysql> select * from message_bak;
+----+-----------+--------------------+---------------------+
| id | name      | content            | time                |
+----+-----------+--------------------+---------------------+
|  1 | weirui    |  xiaozhuqushangban | 2013-11-13 17:10:05 |
|  2 | lemontree |  xiaozhuqushangban | 2013-11-15 13:47:10 |
|  3 | weirui    |  xiaozhuqushangban | 2013-11-16 14:38:42 |
|  4 | weirui    |  xiaozhuqushangban | 2013-11-11 11:11:11 |
|  5 | weirui    |  xiaozhuqushangban | 2013-11-18 17:47:03 |
|  6 | weirui    |  xiaozhuqushangban | 2013-11-19 10:17:17 |
|  7 | weirui    |  xiaozhuqushangban | 2014-11-11 11:11:13 |
|  8 | weirui    |  xiaozhuqushangban | 2013-11-19 10:17:17 |
|  9 | lemontree |  xiaozhuqushangban | 2013-11-19 10:17:17 |
+----+-----------+--------------------+---------------------+
9 rows in set (0.00 sec)

mysql> update message_bak set content ='xiaoxiongquxiaban' where id%2 = 1;
Query OK, 5 rows affected (0.02 sec)
Rows matched: 5  Changed: 5  Warnings: 0