+-----+------+----------+--------+------------+------+---------+---------------------+
| id | uuid | username | domain | attribute | type | value | last_modified |
+-----+------+----------+--------+------------+------+---------+---------------------+
| 145 | 3333 | 0 | | usertype | 0 | manager | 1900-01-01 00:00:01 |
| 137 | 2222 | 0 | | permission | 0 | all | 2012-08-31 14:16:59 |
| 144 | 2222 | 0 | | usertype | 0 | manager | 1900-01-01 00:00:01 |
| 139 | 3333 | 0 | | permission | 0 | all | 2012-08-31 14:17:34 |
| 10 | 4445 | 0 | | usertype | 0 | manager | 1900-01-01 00:00:01 |
| 11 | 4445 | 0 | | permission | 0 | all | 2012-08-07 17:38:50 |
| 39 | 002 | 0 | | permission | 0 | all | 2012-08-20 13:55:42 |
+-----+------+----------+--------+------------+------+---------+---------------------+
如果想查询出attribute为usertype 并且value为manager 中uuid=2222 或者3333的数据。
必须要将或or使用括号括起来。如下：
select * from usr_preferences where attribute='usertype' and value='manager' and (uuid='2222' or uuid='3333');
查询结果如下:
+-----+------+----------+--------+-----------+------+---------+---------------------+
| id | uuid | username | domain | attribute | type | value | last_modified |
+-----+------+----------+--------+-----------+------+---------+---------------------+
| 144 | 2222 | 0 | | usertype | 0 | manager | 1900-01-01 00:00:01 |
| 145 | 3333 | 0 | | usertype | 0 | manager | 1900-01-01 00:00:01 |
+-----+------+----------+--------+-----------+------+---------+---------------------+
转播
