Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 查询某列字段是否存在空回车/空换行符

查询某列字段是否存在空回车/空换行符

WBOY
Release： 2016-06-07 14:54:50
Original
2608 people have browsed it

获取某个对象的list时,如果某列(某属性)存在空回车/空换行符的话,获取list时总是有错误,转json也出错 无 --查询数据中的换行符SELECT *FROM table_nameWHERE INSTR(fidle_name,CHR(13))0 --回车 OR INSTR(fidle_name,CHR(10))0 --换行table_name:要查的表fidl

获取某个对象的list时,如果某列(某属性)存在空回车/空换行符的话,获取list时总是有错误,转json也出错 
--查询数据中的换行符
SELECT *
FROM table_name
WHERE INSTR(fidle_name,CHR(13))>0  --回车 
OR INSTR(fidle_name,CHR(10))>0     --换行


table_name:要查的表
fidle_name:怀疑存在回车/换行的列名
Copy after login
Related labels：
Enter Field exist object newline character Inquire Obtain
source：php.cn
Previous article：类似于split的作用 将字符串, 分隔开成字符数组 Next article：pl/sql:aes256加密解密
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
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
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