mysql \r\n
时间: 2023-09-12 12:12:41 浏览: 121
在MySQL中,\r\n是用来表示回车换行符的特殊字符。如果你想在查询语句中查找包含\r\n的文本,你可以使用以下方法之一:
1. 使用LIKE语句和CONCAT函数:SELECT * FROM tablesA WHERE cola LIKE CONCAT('%', '\r\n', '%');
2. 使用LIKE语句和特殊字符转义:SELECT * FROM tablesA WHERE cola LIKE '%\\r\\n%';
3. 使用REGEXP语句:SELECT * FROM tablesA WHERE cola REGEXP '\\r\\n';
请根据你的具体需求选择适合的方法来查询包含\r\n的文本。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [mysql针对字段中换行符\r\n进行查询和删除](https://blog.csdn.net/liu_yulong/article/details/120776470)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [sqlyog mysql可视化工具](https://download.csdn.net/download/qq_56921846/88244937)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]