Pacific-Design.com

    
Home Index

1. SQL

2. Validate Domains

SQL / 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 '%+%';