Translations:Manually sending individual or bulk SMS messages/5/en
insert into outbox (phone, message, msgid, createdby)
select phone, 'Message to send', 0, 2 -- id of the current user (person creating the messages) from users u where not u.del and phone is not null and left(phone,2) = '62' -- only numbers in Indonesia -- add any other filters here. For example -- and groupid = 4 -- filter for a specific user group