How to turn all wikipedia links in my database into plain text?

[Alfa1]

Is there a query I could use to turn all wikipedia links in my database, into plain text?

[Alfa1]

Can anyone help out here?

Basically I mean that all links with the following syntax:
X (http://en.wikipedia.org/wiki/Link_text)Should be turned into plain text:
Link text
So
organisms (http://en.wikipedia.org/wiki/Organisms)
Should be turned into plain text:
organisms
Can this be translated to a query?