[thelist] MySQL subquery

Mark Groen evolt at markgroen.com
Thu Oct 27 22:50:12 CDT 2005


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




More information about the thelist mailing list