最佳方式：str_replace，嵌套替换[复制]

Question

This question already has an answer here:

• Doing calculations in MySQL vs PHP 5 answers

I have a question, what is the most optimal way for replace the strings for example, I want to replace and with ''. I have 2 options :

1. Replaces nested:

   SELECT REPLACE(REPLACE(m3.old_message,' ',''),' ','')

2. Preg replace:

   if ($aField== 'user') { $sValue = preg_replace... }

Thx in advance.

</div>

Answer 1

In PHP you can do:

$string = preg_replace('/\R/', '.', $string);

Where \R stands for any line break, or or .