Keep forgetting this. Replace a string in all rows:
UPDATE <table> SET <column> = REPLACE(<column>, '<string to find>', '<string to replace>');
Keep forgetting this. Replace a string in all rows:
UPDATE <table> SET <column> = REPLACE(<column>, '<string to find>', '<string to replace>');
Easy to do, never had the need to use it till now:
var text = "this is a / multiline / string / cool huh?";