Re: Odd query behavior

On 03/12/10 18:41, Dan McFadyen wrote:
> Hello,
>
> I've come across an odd situation. I've had access to a database where a
> the following happens:
>
> " SELECT * FROM table WHERE name LIKE 'abc%' " returns 2 rows...
>
> but...
>
> " SELECT * FROM table WHERE name IN (SELECT name FROM table WHERE name
> LIKE 'abc%') " returns 0 rows...

I am sorry if it was already spoken.

SELECT name FROM table WHERE name LIKE 'abc%'

EXPLAIN SELECT name FROM table WHERE name LIKE 'abc%'

EXPLAIN SELECT * FROM table WHERE name IN
(SELECT name FROM table WHERE name LIKE 'abc%')