Professional Web Applications Themes

date delete query - MySQL

Hello, I have a table called DateOfBirth which has dates in the format: '2001-08-23 00:00:00'. I want to make a query which deletes the dates after the year 1996. Would be really thankful if someone helps me with this query. Thanks Ros...

  1. #1

    Default date delete query

    Hello,
    I have a table called DateOfBirth which has dates in the format:
    '2001-08-23 00:00:00'.
    I want to make a query which deletes the dates after the year 1996.
    Would be really thankful if someone helps me with this query.
    Thanks
    Ros

    roohbir Guest

  2. #2

    Default Re: date delete query

    On 20 Mar, 10:49, "roohbir" <com> wrote: 

    Do you mean "deletes records where the column 'colname' has dates
    after the year 1996"?#

    If so, assuming that the column is a date column then
    DELETE FROM `DateOfBirth` WHERE YEAR(`colname`) > 1996

    If it is a text column then
    DELETE FROM `DateOfBirth` WHERE LEFT(`colname`, 4) > '1996'

    Captain Guest

  3. #3

    Default Re: date delete query

    On Mar 20, 4:57 am, "Captain Paralytic" <com>
    wrote: 
    >
    > Do you mean "deletes records where the column 'colname' has dates
    > after the year 1996"?#
    >
    > If so, assuming that the column is a date column then
    > DELETE FROM `DateOfBirth` WHERE YEAR(`colname`) > 1996
    >
    > If it is a text column then
    > DELETE FROM `DateOfBirth` WHERE LEFT(`colname`, 4) > '1996'[/ref]

    Thanks a lot Captain. It worked. The column is a date column.
    Thanks again mate.
    Roohbir

    roohbir Guest

Similar Threads

  1. Help with delete query please
    By Donna Elles in forum MySQL
    Replies: 3
    Last Post: June 2nd, 08:38 PM
  2. date query problem, date in variable
    By roy in forum MySQL
    Replies: 1
    Last Post: October 16th, 11:57 AM
  3. CFFILE Delete, by date
    By StylusDesigns in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: September 17th, 07:33 PM
  4. Delete row in query
    By jarilo in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: February 21st, 12:27 PM
  5. Delete date stamped on a photo
    By Rebekah in forum Adobe Photoshop Elements
    Replies: 2
    Last Post: September 29th, 06:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139