Professional Web Applications Themes

Comparison using mysql - MySQL

Can i use the "LIKE" operator on a date in mysql? I want to compare the information by the different months Thanks Wesley...

Sponsored Links
  1. #1

    Default Comparison using mysql

    Can i use the "LIKE" operator on a date in mysql?
    I want to compare the information by the different months
    Thanks Wesley

    Sponsored Links
    wesley@ispace.co.za Guest

  2. #2

    Default Re: Comparison using mysql

    Sure, this query selects all orders placed in the month of April,
    regardless of the year...

    SELECT date FROM orders WHERE date LIKE '%-04-%';

    strawberry Guest

  3. #3

    Default Re: Comparison using mysql

    thanks:)

    wesley@ispace.co.za Guest

  4. #4

    Default Re: Comparison using mysql

    strawberry wrote:
    > Sure, this query selects all orders placed in the month of April,
    > regardless of the year...
    >
    > SELECT date FROM orders WHERE date LIKE '%-04-%';
    You can, but you can also do:

    SELECT date FROM orders WHERE MONTH(date) = 4;


    Paul Lautman Guest

  5. #5

    Default Re: Comparison using mysql

    that works brilliantly, thanks
    Wes

    wesley@ispace.co.za Guest

  6. #6

    Default Re: Comparison using mysql

    Yes - but that wasn't the question ;-)

    strawberry Guest

  7. #7

    Default Re: Comparison using mysql

    strawberry wrote:
    > Yes - but that wasn't the question ;-)
    True, that was why I was careful to say "You can, but you can also..." :->


    Paul Lautman Guest

  8. #8

    Default Re: Comparison using mysql

    Thanks strawberry and Paul
    You guys are both brilliant;)
    Wes

    wesley@ispace.co.za Guest

Similar Threads

  1. Replies: 0
    Last Post: January 29th, 02:03 PM
  2. Easy for u--comparison
    By emmim44 in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: July 10th, 04:21 PM
  3. comparison between two regexes?
    By David Garamond in forum PERL Beginners
    Replies: 2
    Last Post: October 24th, 02:57 PM
  4. Mac - PC Comparison
    By Ed A. Ortiz in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 6
    Last Post: July 16th, 07:49 PM
  5. raw vs. ufs comparison
    By Jan Andres in forum Sun Solaris
    Replies: 5
    Last Post: July 16th, 10:54 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