mysqli - mysql update, replace spaces and limit -

i have this

en_title cell huawei e160e best modem mobile using, 3g hsdpa    update lang_temp set fi_content = concat( '<a href="http://www.google.fi/search?hl=fi&source=hp&q=', en_title ,'&meta=&aq=f&oqnofollow" target=_blank>google search...</a>') en_content =''; 

i need replace spaces + charters , limit 15 charters value.

in result need get

<a href="http://www.google.fi/search?hl=fi&source=hp&q=huawei+e160e+best+f&meta=&aq=f&oqnofollow" target=_blank>google search...</a> 

how possible? thank you!

use str_replace(" ","+","your url"); replacing spaces + in given url