Removing a set of letters from a string

translate() replaces a set of single characters (passed as a string) with another set of characters (also passed as a string), for example:

translate('abcdef', 'ace', 'XYZ') --> 'XbYdZf'

replace() replaces occurrences of a string of arbitrary length with another string:

replace('abcdef', 'bc', 'FOO') --> 'aFOOdef'

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)