Need expert's help on mysql command for Phpld script

I have a free directory with category dump. However it doesn't contain description for most of the categories (thousands of them).

Could some expert teach me how to use the title of category as the description in mysql command?

Something like this:

If "description" is empty, then use "title" as description.

Thank you very much and green rep ready to give out.

 

run this query.

Update [name of category table] set DESCRIPTION = TITLE



replace the [name of category table] by actual name of category table in you database

 

If you're using MySQL then you should look the IFNULL command that can be used in a select statement. Here's a link to an example:

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull

 

What's the use of such stuff when it will obviously not benefit.

Instead of ruining your db and meta, spend some time and have some good descriptions.

 

problem fixed, don't bother to reply anymore.

Thread closed.