php - MySql date format with word -


I am following the document from here:

This one gave me the result:

Between

  WHERE (DATE_FORMAT) ('2014 03' and '2014 06') but this is not:  <<> < Code>  

I want to use this type of date:

  WHERE (between DATE_FORMAT 'March 2014' and 'June 2014') Code> April 2014  

What did I do? Thanks in advance for any input.

You can not compare stars. The comparison you are looking for is alphabet, so there is nothing because "march"> "june".

The comparison of two stings is more than M alphabetically to J and therefore 2014 is more than 2014 June.

Do not try to use wire for comparative factors


Comments