need to find all records with 2009 from a date string of XX/XX/XXXX

[eluser]Flying Fish[/eluser]
Here's what I've come up with so far, it seems to work well.

Code:

$query = $this->db->query("SELECT * FROM orders WHERE status = 'complete' AND date_ordered REGEXP '^../../2009$' ORDER BY order_id ASC ");

appreciate the feedback