Overcoming MySQL 3x INSERT...SELECT Limitation

[Xeon Masters]

Hi,

Are there any methods to overcome INSERT...SELECT limitiation of not referencing the same table in the FROM clause? (other than upgrading MySQL to a newer version)

I've tried this statement but fails:

INSERT INTO foo SELECT NULL, some_col_name
FROM foo AS fooAlias
WHERE some_constraint
;

I've considered of using views, but alas, it's implemented on v5.

Plz Help
TIA