Advanced Search

Return to Snippet

Revision: 35357
at November 5, 2010 23:52 by howardpanton
Initial Code 
SELECT *
FROM 'table_name'
WHERE year ('date_field')
BETWEEN 2005
AND 2010

To delete all entries use this query

DELETE *
FROM 'table_name'
WHERE year ('date_field')
BETWEEN 2005
AND 2010
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Use this to select all fields between two different dates

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SELECT ALL => MySQL Database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL