MySQL trim

Hi there

I would like to select a string in a field in my database…

Ex. The field is called test. In ‘test’ theres a string called ‘West Coast’.

But I want to select it, taking the space out, and convert it to lower case. Is this possible. I’ve managed to trim it, and make it lower case, but is it possible to take out the space in the middle?

"Select id, lower(trim(test)) from provinces WHERE id = " . $id;

thanx, in advance!