Is there a MySQL equivalent of php's Preg_Replace? [duplicate]

Possible Duplicate:
How to do a regular expression replace in MySQL?

When I search the db for a certain value, say a singular noun like "party", I want to be able to get the value "party" from the db, even though it's actually "parties". For that I thought about replacing the -ies suffix for -y, which didn't have any conspicuous exceptions (maybe "lies").

Is there a MySQL equivalent to the PHP Preg_Replace using regex? Can I handle it otherwise without a mysql function?

so:

SELECT * FROM table WHERE preg_replace('/(.)*ies/','y',column) WHERE column="party";' 

Thanks!