i need to delete rows from MySQL table which is very huge.I have multiple conditions check before deleting the data. my table looks like: data(table name):
name mobile email address source xyz 871 [email protected] 1.txt bac 123 null 2.XLS TST 456 [email protected] 3.xls yup 897 null abcde web null [email protected] hjbsb
so basically i need to delete the rows where value in Source doesnt end with either .TXT or .txt or .xls or .XLS. source is the file-name from which data has been captured.