Deleting records with a certain prefix
If the phone number is like the format 9725551234 then the query would be: Delete from clients where substring(voicephone,4,3)='555' If the phone number format is 972-555-1234 then the query would be: Delete from clients where substring(voicephone,5,3)='555'Related Articles
- Deleting Lists in SpitFire Pro (MySQL Version)
- Searching and Exporting Data in SPD ListMaker Pro
- SpitFire Predictive Pro Campaign Preferences
- Custom Query in SpitFire
- List Won't Import (ListMaker Pro)
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "Deleting records with a certain prefix"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
20th of August, 2008
