[Solved]Set Start Publishing equal Created Date

[allegrande]

Hi,
for all articles, I need to set Start Publishing date (mysql table publis_up) equal Created Date (mysql table created).
How can I do this? What is the script to run in mysql to perform this?

Thanks a lot for answers!

[imanickam]

I believe that you would have used the following SQL statement to address your need.

Code: Select all

UPDATE `xyz_content` SET `publish_up`=`created`;

where xyz_ is the database/table prefix for your Joomla site.

If it is different, please share your solutions so that others can benefit from it.