Pacific-Design.com

    
Home Index

1. Databases

2. Validate Domains

Databases / Validate Domains /

Validate Domains

DELETE FROM database.table WHERE NOT (domain LIKE '%.__' OR  domain LIKE '%.___');
DELETE FROM database.table WHERE domain LIKE '%\'%';
DELETE FROM database.table WHERE domain REGEXP "\\\\";
DELETE FROM database.table WHERE domain like '%--%';
DELETE FROM database.table WHERE domain like "%\n%";
DELETE FROM database.table WHERE domain like '%+%';