how to pick the part of string from URL

Question

HI,
Good Morning!!

http://www.hellohyderabad.com/hyderabad-guide/localities/abids/

I have url like this, in this i need to pick the last string means locality(abids) and i have  to append that last string to my database query, so pls help to me ,
how to pick and append that string to my database query.

Thank you.

Answer 1

Insted of creating another stored procedure why dont you create the DML Trigger on Update it will insert the records into new table. this will not harm on you performance i think.