[Resolved] Mass Replace

[jonno946]

Hi there,

I have a table with 2 fields, "origional_word", and "replace_with".

This list could potentially contain several hundred replacements (i am making a kind of translator).

What would the quickest way of doing this?

My initial thought was loop through each word, and replace all of the occurances of "origional_word" with "replace_with" using str_replace, however is there a quicker way of doing this?

Thanks

Jonathan

[devinemke]

spool both fields into two separate arrays and then use [man]str_replace[/man]. As of PHP 4.0.5, str_replace() can take arrays as both it's search and replace arguments which is exactly what you are trying to do.

[LordShryku]

If this is a MySQL table, you can use the replace function

UPDATE table
SET column = replace(column, original_word, replace_with);

[devinemke]

Originally posted by LordShryku
If this is a MySQL table, you can use the replace function

i was assuming that jonno946 wanted to apply the search and replace rules stored in the db across a given string (which could be fed to str_replace()).

[jonno946]

Thanks 😃

I used devinemke's first suggestion, worked a treat.

Thanks again.

Jonno