[sqlite] search & replace

[IAIN GALLAGHER]

I have a database of scientific references. In that database there is a table 
(bibref) containing a field (Author). I would like to search for ampersand (&) 
and replace it with a semicolon (;) in the Author field. 

How do I do this?

Thanks

Iain