22 lines
341 B
Markdown
22 lines
341 B
Markdown
请使用正则表达式批量替换项目中的以下内容
|
|
|
|
1. find_in_set 替换成 array_position、string_to_array
|
|
|
|
```
|
|
find_in_set\(([^,]+),\s*([^)]+)\)
|
|
```
|
|
|
|
```
|
|
array_position(string_to_array($2, ','), CAST($1 AS TEXT)) IS NOT NULL
|
|
```
|
|
|
|
2. CURRENT_TIMESTAMP 替换成 CURRENT_TIMESTAMP
|
|
|
|
```
|
|
sysdate\(\)
|
|
```
|
|
|
|
```
|
|
CURRENT_TIMESTAMP
|
|
```
|