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>')
