SELECT
	id,
	name,
	IF(name REGEXP '^(the|a|an) ',
		SUBSTRING(name, INSTR(name, ' '	) + 1),
		name
	) AS orderName
FROM 
	movies
ORDER BY 
	orderName ASC