Yes, Triggers... I so rarely use them I forget they exist. On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt <mli...@rp-online.de> wrote:
> Johnny Withers schrieb: > >> Well, I think an update after insert is the only way. Other than >> perpopulating another table with possibe crc values then usinga join: >> >> Select id from testtable >> Inner join crctable on testtable.id=crctable.id >> Where crctable.crcval='xxxxxxx' >> >> Just be sure to index the crcval column. >> > > From my understanding, a TRIGGER might do exactly what Thunder needs. > > http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html > > Ciao, > Thomas Pundt > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net