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 vote357 views1 answer
Mssql unique key accept nulls
SQL
2 votes339 views1 answer
Compare date in sql
SQL
0 vote370 views1 answer
Query builder doctrien return sql
SQL
0 vote339 views1 answer
How to use group_concat in sql server
SQL
0 vote333 views1 answer
Mysql pv progres
SQL
1 vote343 views2 answers
Mysql between
SQL
0 vote342 views1 answer
ORA-00942
SQL
11 votes368 views1 answer
Ddl view
SQL
1 vote324 views1 answer
Convert rows to string sql server
SQL
3 votes335 views1 answer
Oracle revoke grant
SQL