MySQL replace substring in field with another string

in a select

select replace(picon, 'http', 'shit') from mytable
select replace(<field>, '<what>', '<with>') from <table>

in an update

update mytable set picon = replace(picon, 'http', 'shit')
update <table> set <field> = replace(<field>, '<what>', '<with>')