Mysql regular query and string interception

This article focuses on "Mysql regular query and string interception". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "Mysql regular query and string interception".

Set the field

If_name: P-LOCAL to mensLseke ((AS12345/2.3548), NRV 10.12.64.1), 1

If_name: P-LOCAL to mensLseke (AS12345,N:10.12.64.1), 1

The as number in the is extracted and updated to the neighbor_as field of this data.

Update table_name i inner join (select ifIndex, substring_index (if_name,'AS',-1),',', 1)', 1),'/', 1) nas from table_name where if_name regexp'AS [0-9] +') c on i.ifIndex = c.ifIndex set i.neighbor_as = c.nas

At this point, I believe you have a deeper understanding of "Mysql regular query and string interception". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!