mysql> LOCK TABLE locks WRITE; mysql> SELECT * FROM locks where yourcond=true; mysql> INSERT locks (...) VALUES(...); mysql> UNLOCK TABLES;