Getting two rows with 1 query where the second row depends on the first

[CarbonCopy]

I have a table, and the relevant columns are id,url, and url-prefix. Two of my entries have these values

 

{1,'/path/to/gallery',0}
{2,'/path/to/designs',0}

 

and 4 of my entries go like this

 

{3,'gallery1',1}
{3,'gallery2',1}
{4,'designs1',2}
{4,'designs2',2}

 

If I have the url /path/to/designs/gallery1 I want to check to see if it is a valid entry or not. Is there any way to do this in 1 query?

[fenway]

Say what?

[CarbonCopy]

Is there any way to select the url and prefix id from the second set of rows and get the url matching the prefix id from the second?

 

So it would return /path/to/gallery/gallery1 instead of /path/to/gallery AND gallery1

[fenway]

Sounds like you should be able to CONCAT() them together and simply check...