Mysql Query Statement Question

[All4172]

What I'm trying to do is search a field in mysql, and if it has an _ in the file name, change it to a - instead.  And alos change any capital letters to lower case.

 

From:  This_is_my_example

 

To : this-is-my-example

 

I figure it would be something like:

 

UPDATE 'file'  SET '-' WHERE `filename` LIKE '_'

 

I"m not really sure how to put a regular expression in there to only replace the underscore put leave the data.

[akitchin]

you can try using REPLACE(), which will simply replace any instance of a character with a given one:

 

UPDATE table SET column = REPLACE(column, '_', '-')

[All4172]

That worked great.  Is there anything like that to convert capital letters to lower case?

[akitchin]

have a look at this section of the manual.  it has all the mysql functions available to you, of which there are many.  i believe the one you're asking for is UPPER(), but you'll want to make sure of that.