mysql query modification

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

SELECT table1.url FROM table1, table2 WHERE AND
table1.type='xyz' AND table2.status IN( 'Yellow') AND
table2.request='"&test&"'  ORDER BY table2.time DESC"

I am getting data from 2 tables by using a join
that works but the problem is the the column in table 1 "url" has links
in it as enteries
which are actually urls to different pages.
Now this url can be of 3 types- All urls are of type 1 ,2 or 3
1) http://host1/Report/report1.htm.gz

My old query returns results with all the urls
I want to modify it to return only the htm.gz or html.gz urls
Any idea how this can be done

Thanks in advance

Site Timeline