Thinking of moving to London in the next couple of years; where are the best state schools?

[superstarheartbreaker]

Hello there. DD is currently in reception and loving it in our lovely rural backwater small town.
I need to get my career going again and I have always wanted to live in London. The only thing that is stopping me is the thought of sending my dd to school there. Am I mad? I will be prepared to move anywhere where I can afford to. I am a teacher and I will not be rolling in it although I should be able to afford £1000 a month rent for the first year.
I have seen cheap key worker hosuing in Richmond which I know and love but I might not be able to get these until my career is going strong. Am I nuts even considering this? I have doubts about secondary school education in London (although I would be prepared to move back here).
My dd is very keen on performing arts and I just feel that she would love the thriving musical theatre scene in London. I grew up in this small town and although I did have an ok time here I found it very claustrophobic as a teen and because it is a bubble I found it hard to adapt to city life at uni and now I am stuck here again but feel frustrated by lack of opportunity. I don't want the same to happen to dd.
Private school is almost certainly out of the question unless I end up working oin one myself.

have a look online. There was a chart I saw recently which showed that there are about three boroughs in London that have 100% outstanding secondary schools. I think Richmond might be one of them.

My son goes to a wonderful, outstanding primary. There is a lot of choice but you do need to do your homework, and also see what you get for your money. £1,000 a month will get you a three bed house with garden in some parts, and in other parts (and I suspect Richmond will be one) you'll be lucky to get a two bed flat.