Shoutbox

Yea I know the title's confusing so I'll try and explain what I mean.

In the MPSounds.net DB the soundpack names are stored as 'The Simpsons Movie' etc, but I am now making the urls to pack like /soundpacks/the-simpsons-movie.

One solution would be to have a 2nd field in the table with the url friendly version of the name(the-simpsons-movie instead of The Simpsons Movie) but I'm just wondering if it's possible to do something along the lines of:

SELECT FROM blah WHERE MyFunction(title) = 'the-simpsons-movie'

where MyFunction does the lowercasing, removing non alphanumerics etc.  Just wondering if this is possible at all, or do I need to add a new field?

Thanks for any replied