search and update or insert

[csharpy]

I use php and mysql to generate new webpages for my site... what i would like to do is pull information from my mysql database and wherever there is a certain pattern, i would like to insert HTML code before and after that pattern or possibly just replace the pattern. An example would be for creating a link to sayyyy google, wherever there is the term "google" in the text. Hopefully you understand what i'm asking.

 

an example would be...

before the search and insert...

"why don't you try using google for that?"

after the search and insert...

"why don't you try using <a href=http://www.google.com> google </a> for that?

[haku]

strreplace('google', '<a href="http://www.google.com">google</a>');

[Ken2k7]

What haku meant was in PHP, you can do this -

str_replace('google', '<a href="http://www.google.com">google</a>');

 

In SQL, you can do this -

SELECT REPLACE(column, 'google', '<a href="http://www.google.com">google</a>') AS linky
FROM tablename;

[fenway]

This something that doesn't need to be done by the DB.

[csharpy]

Great it worked!  I appreciate the help.  This is the first question i've posted and will be posting more now that i know i get fast support!!!  thanks again!

[Ken2k7]

Great it worked!  I appreciate the help.  This is the first question i've posted and will be posting more now that i know i get fast support!!!  thanks again!

Posting something other than asking-for-help topics would be nice. Give something back to the community. Don't be selfish.