need help with a query

a month i'm using this as part of my query to find entries that are about to expire: ' ... DATE_ADD($dbtable3.savedemployers2, INTERVAL 30 DAY) =NOW()' am i doing this the right way? thanks redmond -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p9 #0

Re: need help with a query

that the DATE_ADD function outputs. So, DATE_ADD(table.date, INTERVAL 1 MONTH) = DATE_FORMAT(CURDATE(), '%Y-%m-%d') I might be off on the 1 MONTH part, but I think it's the right track. -Original Message- From: Redmond Militante [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 6:03

extracting substring from text blob during query

i have to use regular expressions in php or perl to get substrings out after the query? thanks redmond -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p9 #0: Thu Jul 1 14:36:26 CDT 2004 i386 7:30PM up 5 days, 1:34, 2 users, load averages: 0.04, 0.03