mysql - 字符串搜索查询中的空格导致搜索返回没有结果
问题描述
我正在尝试搜索 mySQL 数据库并返回具有最大版本的结果,但是当搜索中有空格时,它总是返回没有结果。
我曾尝试在查询的 select MAX 中使用替换,但这只会导致语法错误。
SELECT document_versions.payload, document_versions.version
FROM document_versions
INNER JOIN documents ON documents.guid = document_versions.document_guid WHERE document_versions.title = @name
AND documents.document_type_id = 35
AND document_versions.version =
(SELECT MAX(version) FROM document_versions WHERE title = @name)
我也试过
SELECT document_versions.payload, document_versions.version
FROM document_versions INNER JOIN documents ON documents.guid = document_versions.document_guid
WHERE REPLACE(document_versions.title,' ','') =
REPLACE(@name,' ','')
AND documents.document_type_id = 35
AND document_versions.version =
SELECT MAX(version) FROM document_versions
WHERE REPLACE(title,' ','') = REPLACE(@name,' ',''))
这也没有返回任何结果。
解决方案
你试过这样吗?
SELECT document_versions.payload, document_versions.version
FROM document_versions
INNER JOIN documents ON documents.guid = document_versions.document_guid
WHERE document_versions.title = @name
AND documents.document_type_id = 35
ORDER BY document_versions.version DESC LIMIT 1
推荐阅读
- python-3.x - 如何计算odoo 12中两个日期之间的差异
- docker - Docker: create database schema on image build is not working
- arduino - Serial communication with Arduino Uno in hexadecimal, and monitoring response with serial monitor
- python-3.x - 网页抓取 Innerhtml
- c++ - 为什么这段代码用 g++ 而不是 MSVC++ 编译?
- c# - 为什么在控制台应用程序中使用 CommonOpenFileDialog 时会出现此异常?
- logstash - 即使管道失败,Docker 上的 Logstash 也会继续运行
- python - Strange behavior when dragging a QTreeWidgetItem on macOS Sierra
- java - Can not extract Double[] from resultset
- deep-learning - 文学中“权重捆绑”表达的形式意义