auto linking URL to keyword

[Superfrappe]

Hey all!

So I have a basic CMS built in php/mysql and I'm trying to figure out how to add the functionality of being able to go into the admin section, add a link to a field, and then it's URL to a field and updating the table. Simple.

What I'm trying to wrap my head around is how, whenever I type that word in a new article, and submit... when the article is pulled into the live page, how can I have the word updated automatically with the URL and be a link?

This seems like an easy task - but I just haven't tried something like this before.

Has anyone done this or have any advice on how to go about this?

Thanks all!

[Superfrappe]

Update:

So I've got the table built, and I'm able to add/mod/delete the text/URL. I am also able to pull the text/URL into one page.

The question is - how can I have a feature that will go through the entire site and wherever it sees, say the word "paradigm" it will attach a URL to the link?

Thanks in advance all!

[Znupi]

Um. str_replace() (http://php.net/str-replace)?