select * from voucher where prefix='JP10' and voucher_no between 67870 and 67872; select * from voucher_campaign where campaign_code like '%Keppel%'; select * from voucher_campaign_issue where voucher_id in (363962,363963,363964); select * from voucher_action where voucher_id in (363962,363963,363964) and action_id = 30; select * from voucher_campaign_issue_request where request_id = 61549; select * from voucher_request_approve where request_id = 61549; select * from voucher_receipt_numbers where voucher_ids like '%363962%';
=========================================================================================================
select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 51161 and 51162 select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 50115 and 50124 select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 48000 and 48009 select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 47941 and 47942 select* from voucher_campaign #189 select * from voucher_campaign_issue where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) #update voucher_campaign_issue set campaign_id = 189 where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) select * from voucher_request_approve where request_id in (58643,58653,58740,58885) #update voucher_request_approve set request_remarks = REPLACE (request_remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where request_id in (58643,58653,58740,58885) select * from voucher_campaign_issue_request where request_id in (58643,58653,58740,58885) #update voucher_campaign_issue_request set campaign_id = 189 where request_id in (58643,58653,58740,58885) select * from voucher_action where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30 #update voucher_action set remarks=REPLACE (remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30