Advanced Search

Return to Snippet

Revision: 27827
at June 24, 2010 20:28 by galofre
Initial Code 
SELECT *
FROM
tablename
WHERE
tablename.tabledatefield < DATE_SUB( NOW(), INTERVAL 7 DAY )
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Display records older than one week.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Select Records older than one week

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL