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