add + sign before the number in mysql

 How to add + sign before the number in mysql

 Its concaticate function in mysql

just use this command in mysql cli or inline in phpmyadmin:-

> Update vicidial_inbound_dids  set did_pattern=concat('+',did_pattern)

 

replace ++ with + sign command

 

> update vicidial_inbound_dids set did_pattern=replace(did_pattern,'++','+')

 

 To replace content of did_description with group_id

> update vicidial_inbound_dids set did_description=did_pattern

 

 To replace content of did_carrier_description with group_id

> update `vicidial_inbound_dids` set did_carrier_description=group_id

To change the extension in "No-Agent In-Group Extension" and in "Max Queue In-Group Extension" in the inbound_in_group

> update vicidial_inbound_dids set  no_agent_ingroup_extension=1003,max_queue_ingroup_extension=1004  WHERE `group_id`='groupID' 

 To change the extension in "No-Agent In-Group Extension" and in "Max Queue In-Group Extension" of all ingroups

> update vicidial_inbound_dids set  no_agent_ingroup_extension=1003,max_queue_ingroup_extension=1004

To verify the above changes:`i`

SELECT no_agent_ingroup_extension,1003,max_queue_ingroup_extension,1004 from vicidial_inbound_dids WHERE `group_id`='groupID' 

To change the no_agent_ingroup_id of inGroupID5

> update vicidial_inbound_dids set no_agent_ingroup_id='Recovery_TimeOut' WHERE group_id='RecoveryUK5'

 

 To change "no_agent_ingroup_redirect" to "DISABLED"

> update vicidial_inbound_dids set no_agent_ingroup_redirect='DISABLED' WHERE group_id='CANADA'

 

To change the next_agent_call of inGroupID5

> UPDATE `vicidial_inbound_groups` SET `next_agent_call` = 'inbound_group_rank_wait_time' WHERE `vicidial_inbound_groups`.`group_id` = 'unknown';  

To change the filter_inbound_number and filter_phone_group_id

update vicidial_inbound_dids set filter_inbound_number='GROUP',filter_phone_group_id='blockinboind1'

To move the DIDs from Group2 to Group1

> update `vicidial_inbound_dids` set group_id='Group1' where group_id='Group2'  

 To get the number of calls of specific number with less then 15 sec duration

SELECT * FROM `call_logs`
where call_to='+4411223344566' and todaydate >'2021-03-14' and duration <15