Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 求助大神！如何批量删除数据库表中某个字段中相同的一段字符！

求助大神！如何批量删除数据库表中某个字段中相同的一段字符！

WBOY
Release： 2016-06-07 16:01:44
Original
1236 people have browsed it

不好意思 昨天官网审核的时候把我截图删了 现虚拟一张表 表Table ID Site_A 1 AM01-1,AN01-1,AL01-1 2 AM01-1,AL01-1,AM06-1 如何批量删除表中Site_A字段中带有字符‘M’的字符串？

不好意思 昨天官网审核的时候把我截图删了 现虚拟一张表

表Table

ID Site_A

1 AM01-1,AN01-1,AL01-1

2 AM01-1,AL01-1,AM06-1

如何批量删除表中Site_A字段中带有字符‘M’的字符串？

Related labels：
delete Great God how Field batch database in the table
source：php.cn
Previous article：简单的存储过程的使用 Next article：Chapter2UserAuthentication,Authorization,andSecurity（7）：
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity> This is my endpoint http://localhost:8080/country/all replies are ok for all countries and...
From 2024-04-06 17:11:03
0
1
421
Understand the inner workings of the Nuxtjs auth module I'm actually trying to integrate the Nuxtjsauth module into my project but I can't underst...
From 2024-04-06 15:38:16
0
1
371
How do I get my image to appear on the page's main display? What I want to do is receive some photos using NASAAPI. These photos are then displayed on...
From 2024-04-06 15:33:12
0
1
433
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template