title: mysql add http:// to all records in website column
body: <p>I'm almost done transferring/reconstructing a substantial mysql db for new application. Column 'website' shows 'www.example.com'. Because the new application reads it as a hyperlink, I need the column to read '<a href="http://www.example.com" rel="nofollow">http://www.example.com</a>'. Is there a way to add the 'http://' in the beginning of each record for that column? Thanks in advance!</p>