Marcel wrote:
I get:
Empty set (0.00 sec).
I couldn't repeat that. Could you provide similar commands as I provide
below to create the table and insert test material to there which allows
to repeat your problem?
# To create test environment
create table pets(pet text);
insert into pets values('dog');
insert into pets values('dog');
insert into pets values('lama');
insert into pets values('cat');
insert into pets values('lama');
# To test it
mysql> SELECT DISTINCT pet from pets;
+------+
| pet |
+------+
| dog |
| lama |
| cat |
+------+
3 rows in set (0.00 sec)
mysql> SELECT DISTINCT pet from pets WHERE pet IN ('lama');
+------+
| pet |
+------+
| lama |
+------+
1 row in set (0.00 sec)