2007-10-11 01:39:55
SELECT a.buid, a.breader, a.bsubject, a.bsender, a.bwdate, a.bsjungri, a.bmemo, b.busrid, b.brdate, b.bcount, b.brjungri
FROM biks_now_memo AS a
LEFT JOIN biks_read_user AS b ON a.buid = b.buid
AND CASE WHEN a.breader <> \'[==*]\'
THEN a.breader = a.breader
ELSE a.breader IS NOT NULL
END
WHERE a.bsender = \'sokj00\'
AND a.bsjungri = \'j\'
ORDER BY buid DESC
LIMIT 0 , 10

    2007-10-08 19:45:07
UPDATE biks_now_memo set
visit = case when reader =\'sokj00\' then visit+1 else visit end
WHERE uid=\'13\'