Thanks r937, just tried it out, that's perfect!!
(Karver) The + && * were added at post time to make it clear about what I was asking, they were not part of timestamp ;-)
Hi,
I have a shopping cart table that I want to clean up. The rule I want to use to cleanup the table is:
If the user added their last item (marked with *) to the cart more than 30 minutes ago delete everything for that user.
USERID TS
18 2006-07-05 20:57:12
18 2006-09-05 22:12:27
18...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.