Mysql faster delete

rule of thumb:
delete 1000 rows at a time.
check affected rows until zero.

example:
delete from `atable` where afield like '%something%' limit 0,1000;

Similar codes

0 vote207 views1 answer
Java spring boot connect to sql server
SQL
0 vote174 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote192 views1 answer
How to check oracle index table
SQL
0 vote195 views1 answer
Postgres grep entire database
SQL
0 vote183 views1 answer
Postgresql not in alternative
SQL
1 vote180 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote203 views2 answers
How to combine two sql queries in one result
SQL
3 votes174 views2 answers
Sql paging query
SQL
0 vote192 views1 answer
Template MySQL Zabbix agent
SQL
2 votes170 views1 answer
Update with join sql server
SQL