PHP mySQL - replace some string inside string -


I have all comma , in , & lt; Space & gt; Change the in my mysql table in all the address table.

For example, 

  + ---------------- + - ---------- ---- + | Name | Address + ---------------- + ---------------- + | Any name A1, street name. + ---------------- + ---------------- +

these

In> 
  + ---------------- + ---------------- + | Name | Address + ---------------- + ---------------- + | Any name A1, street name. + ---------------- + ---------------- +

Thanks in advance 

  update tabl SET address = REPLACE (address, ',', ',')

Back up your table before exiting it!

You can read more about changing the function here:


Comments

Post a Comment