Hello all!

This has to do with the underscores the program seems to put into catagory urls that contain spaces.

I found that if I changed the value of "Death/Death and Funeral Customs" in the "full name" field in the database, using mysqlman, to "Death/Death-and-Funeral-Customs" in my mysql database, when built it looks like this Death/Death-and-Funeral-Customs in my directory instead of this:
Death/Death_and_Funeral_Customs

I have over 100K entries in my database so doing this by hand to the rest of the entries is out of the question.

I am hoping some of you talented gurus can tell me how to do an extended find and replace so I can trade all blank spaces for a hyphen, in just the "full name" field.

Any ideas?

Thanks

Mike

BTW the project I am working on is at http://www.spiritandsky.com

Make sure you back up your database first as this is off the top of my head.

UPDATE Category SET Full_Name = REPLACE(Full_Name," ","-")

Heyya thanks! This looks like what I am looking for!

Now for the romper room question:

Where do I put that command in? What script or program? I am too green to figure out where that commmand would go... I need some specfics, my specialty is html design not scripts and databases.

Thanks

Mike

Go to Database->SQL Monitor and paste it into the box.

mysql> UPDATE Category SET Full_Name = REPLACE(Full_Name," ","-")
-> ;
ERROR 1146: Table 'directory.Category' doesn't exist

I am logged into the correct database after logging in to mysql. As you can see it returned an error..

You'll need to put your table prefix in - probably lsql_Category

You are truly the man!

This worked! Thanks!

Mike

Glad it worked.
Laura.
(maybe I need to change my username to something more gender specific )

LOL

Sorry bout that...