How sublime uses regular expressions to modify data in batches

The following tutorial column of sublime will introduce to you how sublime uses regular regularization to modify data in batches. I hope it will be helpful to friends in need!

The requirements are as follows:

Remove the letters and numbers in front of these knowledge points
If you use a php script to change them one by one, Because the amount of data is too large, it may cause data congestion or server crash.
Use the sublime editor to open the sql file of the table. Query these prefixes regularly, replace them with blanks in batches, and then rerun sql to generate the data table.

The regular statement is as follows:

This solves the seemingly complicated problem~

The above is the detailed content of How sublime uses regular expressions to modify data in batches. For more information, please follow other related articles on the PHP Chinese website!