Two operations - One column

[DKailen]

I have a table that is all good except for one of the columns. In this column (~5500 entries) I have filenames basically such as graphic.jpg. I need to add "pics/" to the beginning of the column.

The other thing that I need is to place something like "No pic on file" where there are empty cells.

Is there an easy way to accomplish these things?

Thanks!
Jim

 

[vacunita]

Sure, Use a couple of Update statements:

UPDATE mytable SET fieldname=concat("pics/",fieldname) WHERE fieldname !="" AND fieldname IS NOT NULL; 

and

UPDATE mytable SET fieldname="No pic on file" WHERE fieldname IS NULL OR filedname = "";

I suggest you run them on sample data just to make sure everything works as expected before running it on the actual table.

Also I added the check for null in case some of your fields are actually null instead of just being empty.


----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[DKailen]

Outstanding! I have been trying to get it to work since yesterday afternoon using the docs.....

Thanks much
Jim