Title
-------
The Labor
Der Lancet
La xxxx
Sciences
.
.

UPDATE Titles SET Title=REPLACE (Title, REGEXP......, '')

CREATE TABLE prefixes (
	prefix CHAR(10) NOT NULL PRIMARY KEY,
	plength TINYINT NOT NULL DEFAULT 0,
	KEY (plength)
);

INSERT INTO prefixes (prefix) VALUES
('De'), ('The'), ('Der'), ('La'), ('Le');

UPDATE prefixes SET plength = LENGTH(prefix);

UPDATE titles AS t
SET t.title = CONCAT(
	SUBSTRING(
		t.title, 
		2 + (
				SELECT p.plength 
				FROM prefixes AS p 
				WHERE LOCATE(p.prefix, t.title) = 1 
				ORDER BY p.plength DESC 
				LIMIT 1
			)
	), 
	' (',
	(
		SELECT p.prefix 
		FROM prefixes AS p 
		WHERE LOCATE(p.prefix, t.title) = 1 
		ORDER BY p.plength DESC 
		LIMIT 1
	),
	')'
	)
WHERE
	EXISTS (
		SELECT * 
		FROM prefixes AS p 
		WHERE LOCATE(CONCAT(p.prefix, ' '), t.title) = 1
	);

UPDATE titles t, prefixes p
SET t.title = CONCAT(SUBSTRING(t.title, p.plength+2), ' (', p.prefix, ')')
WHERE
	SUBSTRING(t.title, 1, p.plength+1) = CONCAT(p.prefix, ' ');