diff --git a/openbsc/src/libmsc/db.c b/openbsc/src/libmsc/db.c
index 1580acd..90c66c8 100644
--- a/openbsc/src/libmsc/db.c
+++ b/openbsc/src/libmsc/db.c
@@ -1042,8 +1042,8 @@
 	dbi_result_free(result);
 
 	result = dbi_conn_queryf(conn,
-			"DELETE FROM SMS WHERE sender_id=%llu OR receiver_id=%llu",
-			subscr->id, subscr->id);
+			"DELETE FROM SMS WHERE src_addr=%s OR dest_addr=%s",
+			subscr->extension, subscr->extension);
 	if (!result) {
 		LOGP(DDB, LOGL_ERROR,
 			"Failed to delete SMS for %llu\n", subscr->id);