How do I remove
<noindex><script>stuff</script></noindex>
in an SQL export using regex in Notepad++ ?
It would help if you explained a bit more. From your question it seems like you need something like this, but that's probably not what you intend.
<noindex><script>.+</script></noindex>