[thelist] MySQL subquery

[Mark Groen]

I've got a conundrum in that MySQL < 4.1 does not support subqueries. Is
there another way to do a query such as this one below without
upgrading?:

update t1 set repname = (select t2.value
      from t1
      where t2.attributeid = '4' and t2.userid = t1.id)

cheers,

        Mark