JDBC error

Guys having a problem with an assignment I'm doing. I have to connect to a database using JDBC and perform CRUD operations on it. I can get most of it working but I'm getting an DBException with the update method.

Heres the exception :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 1' at line 1

Heres the update method :

private static final String TABLE_NAME = "shop";
private static final String COLUMN_ID = "id";
private static final String COLUMN_NAME = "name";
private static final String COLUMN_ADDRESS = "address";
private static final String COLUMN_TURNOVER = "turnover";

public boolean updateShop(Shop s) throws SQLException{
    
        String query;
        PreparedStatement stmt;
        int numRowsAffected;
        
        query = "UPDATE " + TABLE_NAME + " SET " + 
                COLUMN_NAME+ "      = ?, " +
                COLUMN_ADDRESS + "  = ?, " +
                COLUMN_TURNOVER + " = ?, " +
                "WHERE " + COLUMN_ID + " = ?";
        
        stmt = mConnection.prepareStatement(query);
        
        stmt.setString(1, s.getName());
        stmt.setString(2, s.getAddress());
        stmt.setDouble(3, s.getTurnover());
        stmt.setInt(4, s.getId());
        
        numRowsAffected = stmt.executeUpdate();
        
        return (numRowsAffected != 1);
    }

If someone could point me in the right direction I would really appreciate it.

I'm on a mac using Netbeans 7.4 and MySQL 5.5.33

Thanks