Like @Bart McEndree suggested. You may temporarily replace ; enclosed by "

Example :

SELECT REPLACE(REPLACE(REPLACE(text, '";"', '"\xff"'), ';', ''), '"\xff"', '";"') FROM <table>;

In this example, I temporarily replace ";" by "\xff", but you may change that.