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