i want to replace all blankspaces in the Title field in my database with  .

so for example if the title is 12 days - i would like to change it to 12 days

is there any easy way of doing this?

thanks

PHP Code:

preg_replace(' ', ' ', $title); 


I didn't know preg_replace would work that way, without a REGX pattern. Cool. He could also do:

PHP Code:

$title=str_replace(' ',' ',$title); 


I have tried this but get the response:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '$Title=str_replace(' ',' ',$Title)' at line 1
.

I am using phpmyadmin 2.6.1 for my sql commands