2010-01-18
2010-02-01
2010-02-15
2010-03-01
2010-03-15
2011-04-11
2011-04-25
2011-05-09
2011-05-23
2011-06-06
2011-06-22
2011-07-04
2011-07-18
2011-08-01
2011-08-15
2011-08-29
2011-09-12
2011-09-26
2011-10-10
2011-10-24
2011-11-07
2011-11-21
2011-12-05
2011-12-19

    function updateFullNumber(){
        foreach($this->show_info() as $key=>$value){
            $this->trimFullNumber($value['id'], $value['full_number']);
        }
        return true;
    }
    
        function return_date() {
        $sql = "SELECT DISTINCT date FROM `".self::$table."`";
        return connectDb::sql($sql);
    }
    
    /**
     * select users from table #2
     */
    function show_date() {
        $name = '';
        $res = $this->return_date();
        if(mysql_num_rows($res) > 0) {
            while($row = mysql_fetch_assoc($res)) {
                $name .= $row['date'].'<br />';
            }
        } else {
            echo 'String in db is empty';
        }
        return $name;
    }

SELECT DISTINCT SUBSTRING(`date`,1,4) as year FROM your_table

SELECT DISTINCT EXTRACT(YEAR FROM `date`) FROM `tablename`

SELECT DISTINCT YEAR(`date`) FROM `tablename`

DISTINCT left(date,4)