In the last episode (Dec 20), Johnny Withers said:
> On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> > I have table post (id INT and parent VARCHAR)
> >
> > +--+-+
> > | id | parent |
> > +--+-+
> > |1 | 0 |
> > |2 | 0 |
The sub-select only returns a single row, so IN(...) is only looking at a
single value in the list .. it doesn't "expand" to into IN (5,7,11).
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> I have table post (id INT and parent VARCHAR)
>
> +--+-+
> | id | parent
I have table post (id INT and parent VARCHAR)
+--+-+
| id | parent |
+--+-+
|1 | 0 |
|2 | 0 |
|3 | 1 |
|4 | 0 |
|5 | 1 |
|6 | 0 |
|7 | 1,5 |
|8 | 1,5 |
