Re^2: Search a SQL Table and Delete Records

Right now I just want to test something simple, by just searching one field in the record for keywords like http, www, .com, etc. I know I could do this in the database, but since I'm learning a bit of perl scripting, and I can run it on my site, I thought this would be a good way to learn how I can apply things together. Thank you for replying =)

Comment on Re^2: Search a SQL Table and Delete Records

Replies are listed 'Best First'.
Re^3: Search a SQL Table and Delete Records by ww (Archbishop) on Aug 29, 2014 at 01:56 UTC
Learning Perl? Excellent! Learning Perl by applying it when not needed and in a way that makes the specific problem more complex to solve? Not usually advised. But for this quest: use DBI as recommended above; capture each row's id and the relevant field's contents to an array; use a regular expression to search the elements for whatever words you consider earmarks of spam (and NB roboticus' comment thereon) and when found, use the row id to tell your db engine to delete those rows. Adopting this scheme will be a SMOP... but one that is actually fairly 'simple' and one which provides a really relevant problem case for your effort to learn Perl. check Ln42!	[reply]
Re^4: Search a SQL Table and Delete Records by Katanya (Novice) on Aug 29, 2014 at 02:08 UTC
Oh cool! I was wondering how I could get it to figure out which records it needed to delete. I will see if I can get this sorted out tonight. I understand the DBI part, it's just getting the searching and deleting part pieced together. Thank you both for the tips!	[reply]