So I have a table, with field 'short' that contains shortened version of urls.
Right now row['short'] on each row would outuput links like this:
But I want it to output:
So I tried this:
update videos2 set short = replace(short, ‘on.fb.me’, ‘bit.ly’) WHERE length('short') > 0
But It gives me error:
#1054 - Unknown column 'â€˜on.fb.me' in 'field list'
short is a varchar(30) utf8_general_ci by structure.