Change all empty image fields to a specified image?

[Guest]

Hi,

 

I have quite a few products in my database but some of them dont have an image.

Is it possible to do a mySQL querry or something in phpMyAdmin to set all empty image fields to a specified image?

 

Also within my MODEL field I have text I want to remove, for example in:

P1232 - TRV - 3422

and

P3242 - TRV - 9940

etc

I want to remove all the TRV bits.

Can I do that with a mySQL querry? (or any other way)

 

I have looked long and hard at the database in phpMyAdmin but I cant figure it out!

Hope somebody can help me, or I will be editing records for days!

 

Thanks,

Trevor.

[Guest]

OK I figured out a way to do it so here it is in case anyone else finds it interesting:

 

As usual I have come up with a very inelegant, but working, solution!

 

 

EXPORT the whole database

 

SEARCH AND REPLACE with a text editor

 

DELETE DATABASE on server

 

CREATE EMPTY DATABASE on server

 

SQL QUERY TO INPUT your textfile!

 

 

Yes I know its a lame way to do it, but like I said, it worked.

 

Its also useful to export and import like this if you are changing to an older version of MySQL like I had to when I changed to a new hosting company that was using an older version.

 

;)