Please solve my mysql problem

I have field on mysql

ID | Title
------------
1 | Xxxx Yyyyy
2 | Www ZZZ

I need to change to

ID | Title
------------
1 | xxxx_yyyy
2 | www_zzzz

How to do it ?

Use the ALTER TABLE function in MySQL. Also check if your host provides PHPMyAdmin, it's a MySQL maintenance script which you should find useful.

Im assuming you want to replace all the spaces in the values with underscores..?

try...

PHP Code:


$res = mysql_query("SELECT * FROM myTable");

while( $arr = mysql_fetch_array($res) )
{
$ID = $arr['ID'];
$Title = str_replace(" ", "_", $arr['Title']);

$res2 = mysql_query("UPDATE myTable SET `Title` = '$Title' WHERE `ID`='$ID'");

} 


Along those lines anyway - thats not tested or anything...

Actually, I think stoot98 has understood your question much better then me. Go for his answer

You don't need to go into PHP to do that

A very simple query in MySQL is all that is needed and would be a LOT quicker than fetching all the records in a loop then sending them back again.

UPDATE table SET title = lower(replace(title," ","_"))

Let the database do the the work. It's far more efficient at it.

I think this problem has been solved nicely. The second is quite shortly complete.