Gurus
I'm having trouble understanding the column type SET.
To explain my problem, I'll create a table, populate
it, and do selects.
mysql> CREATE TABLE settest( chain SET( "A", "B", "C" ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql> INSERT INTO settest SET chain="A,C";
mysql> SELECT * from settest;
+-------+
| chain |
+-------+
| A,C |
+-------+
mysql> SELECT * FROM settest WHERE chain="A,C";
+-------+
| chain |
+-------+
| A,C |
+-------+
mysql> SELECT * FROM settest WHERE chain="C,A";
Empty set (0.00 sec)
or
mysql> SELECT * FROM settest WHERE FIND_IN_SET("C,A", chain);
Empty set (0.01 sec)
In reading MySQL Reference Manual, this second select statement
should work. But in version()=3.23.49-nt-log, it does not.
In my understanding of set theory, if a SET has A,B,C
A,C == C,A
Can anyone tell me what I'm missing?
BTW, for my application, I'm only interested in unique entries.
---
David E Lopez
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
