Jump to content

i need a simple SQL query.


kevinkhan

Recommended Posts

Im looking for a query to update a published column to 0 if the value is equal to 4 and it is created more than two days ago. The published field is stored as a unix time stamp as an int data type..

 

Here is the query i have so far

 

UPDATE Classified set `published`= 0 WHERE `published` = 4 AND `created` > 2 days old

 

here is the structure of the table

 

CREATE TABLE IF NOT EXISTS `Classified` (

`id` int(11) NOT NULL auto_increment,

`created` int(11) NOT NULL,

`modified` int(11) NOT NULL,

`published` tinyint(1) NOT NULL default '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1498 ;

 

can anybody help me with this?

Link to comment
https://forums.phpfreaks.com/topic/211623-i-need-a-simple-sql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.