Re: Find between char field

From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 25 Apr 2016 16:53:28 GMT
Message-ID: <between-20160425174513_at_ram.dialup.fu-berlin.de>

wilsonfalai_at_gmail.com writes:

>I want to do a search and return all records from a period
>Example:
>SELECT ... AND (`periodo_referente` BETWEEN '01/2016' AND '04/2016')

  Usare questo ordine »MM/AAAA« (invece di »AAAA-MM«) è quasi   come stabilito di una persona non educato sulla tecnologia   informatica!

>Could anyone help me solve this select?

mysql> SELECT A FROM


    -> ( SELECT '06/2014' AS A UNION

    ->   SELECT '07/2014' UNION

    ->   SELECT '08/2014' UNION

    ->   SELECT '09/2014' UNION

    ->   SELECT '10/2014' UNION

    ->   SELECT '11/2014' UNION

    ->   SELECT '12/2014' UNION

    ->   SELECT '01/2015' UNION

    ->   SELECT '02/2015' UNION

    ->   SELECT '03/2015' UNION

    ->   SELECT '04/2015' UNION

    ->   SELECT '05/2015' UNION

    ->   SELECT '06/2015' UNION

    ->   SELECT '07/2015' UNION

    ->   SELECT '08/2015' UNION

    ->   SELECT '09/2015' UNION

    ->   SELECT '10/2015' UNION

    ->   SELECT '11/2015' UNION

    ->   SELECT '12/2015' UNION

    ->   SELECT '01/2016' UNION

    ->   SELECT '02/2016' UNION

    ->   SELECT '03/2016' UNION

    ->   SELECT '04/2016' UNION

-> SELECT '05/2016' UNION
-> SELECT '06/2016' )AS T
-> WHERE
-> SUBSTRING( CONCAT( A, A ), 4, 6 )
-> BETWEEN '201601' AND '201604';
+---------+
| A |
+---------+

| 01/2016 |
| 02/2016 |
| 03/2016 |
| 04/2016 |

+---------+
4 rows in set (0.00 sec)

  E non dimenticate le regole della normalizzazione:   Ogni valore (cella) dev'essere /atomica/! Received on Mon Apr 25 2016 - 18:53:28 CEST