Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 查找替换表中TEXT字段类型数据

查找替换表中TEXT字段类型数据

WBOY
Release： 2016-06-07 14:56:35
Original
1267 people have browsed it

查找替换表中TEXT字段类型数据 无 SELECT REPLACE(SUBSTRING(Comment,1,DATALENGTH(Comment)),',','##') FROM COMPANY

查找替换表中TEXT字段类型数据 
SELECT REPLACE(SUBSTRING(Comment,1,DATALENGTH(Comment)),',','##') FROM COMPANY
Copy after login
Related labels：
text Field data replace Find type surface in the table
source：php.cn
Previous article：SQL Server获取所有数据库名、表名以及字段名 Next article：更新数据库中表的统计信息
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
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
Can a workerpool declared in multiple routes still maintain its cpu usage without caring about the threshold I'm hoping to find a node.js system with a workerpool to handle CPU intensive tasks, but I...
From 2024-04-06 19:54:23
0
1
444
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