Call to same table in subquery

[jackola]

Hello,

I often find answers here but never posted. I have this query I can't quite figure out and was curious if anyone knows if it's possible.

 

Basically I'm using htaccess in URLs and want to make sure that pages are being viewed as intended:

 

whatever.com/what/okay

 

SELECT * FROM pages
WHERE URL = "okay"
AND ParentID IN (SELECT ID FROM pages WHERE URL = "what")

 

ParentID is the ID of the parents, in this case "what".

 

Doesn't seem to work. i think it's because it's a call to the same table?

 

Of course, I can just run that subquery first (using split("/",$_SERVER['REQUEST_URI'])), but thought this an interesting question anyway.

 

MySQL version = 4.0.27-standard-log

 

 

Any ideas?

[toplay]

Try something like this:

 

SELECT

           p1.*

FROM

           pages p1, pages p2

WHERE  1

           AND p1.URL = 'okay'

           AND p1.ParentID = p2.ID

           AND p2.URL = 'what'

;