使用sql 将 /tmp/live/nas/561770113380-三只羊网络/2023-04-14 三只羊网络-2/transcoding/三只羊网络-230414223051.mp4 中的 第五个/和第六个/之间的内容替代为xxx
时间: 2023-09-28 18:04:22 浏览: 42
假设你要替换的内容指的是路径中的一段,可以使用下面的SQL语句:
```
UPDATE table_name SET column_name = REPLACE(column_name, SUBSTRING_INDEX(SUBSTRING_INDEX(column_name, '/', 6), '/', -1), 'xxx') WHERE column_name LIKE '/tmp/live/nas/561770113380-三只羊网络/2023-04-14 三只羊网络-2/transcoding/三只羊网络-230414223051.mp4/%/%/%';
```
请将 `table_name` 和 `column_name` 替换为实际的表名和列名。这个SQL语句会将满足路径匹配条件的记录的指定路径段替换为 `xxx`。
相关问题
vue-aliplayer-v2
Vue-aliplayer-v2 is a Vue.js component for integrating the Alibaba Cloud Player version 2 (Aliplayer v2) into Vue.js applications. With this component, you can easily embed videos and live streams with various features such as playback controls, quality switching, and ad insertion. Aliplayer v2 is a powerful video player designed for delivering high-quality and reliable video streaming across different platforms and devices. It supports various video formats, including HLS, RTMP, MP4, and FLV, and provides advanced features such as real-time transcoding, DRM protection, and AI-powered video analysis. By using Vue-aliplayer-v2, you can create engaging and interactive video experiences for your users and enhance the overall performance and scalability of your video applications.
ffmpeg-android-java
ffmpeg-android-java is a Java library that provides an interface to the FFmpeg multimedia framework on Android devices. It allows developers to easily incorporate multimedia processing and manipulation functionality into their Android applications using Java code. The library supports a wide range of multimedia formats and codecs, including video, audio, and image formats. It also provides support for live streaming and transcoding of multimedia content. The library is open source and can be downloaded from GitHub.
相关推荐
![.zip](https://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)