使用 blob 数据搜索 MySQL 数据库？
是否可以使用 blob 数据搜索 MySQL 数据库以查找与其他 blob 数据类型的密切匹配？
我已经创建了数据库，并将图像存储为 blob。我想知道是否可以拍摄一张与数据库中相似的图片，将其转换为 blob 并使用它来搜索数据库以找到已经存在的相似图片？我的钱是不，但我想我还是会问一下。如果不可能，您是否介意提示我需要做什么才能完成与我的问题相同的任务？
提前致谢！
Is it possible to search through a MySQL database using blob data to find close matches with other blob data types?
I have created my database with images stored as blob. I was wondering if it was possible to take a picture similar to the one in the database, convert it to blob as well and use it to search the database to find the similar picture already there? My money is on no, but I thought I would just ask it anyways. And if it isn't possible would you mind giving a hint as to what I need to do in order to accomplish a task along the same lines as my question?
Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
绝对不是。 MySQL 不知道 BLOB 列中的字节意味着什么——它甚至不知道它们是图像，更不用说如何解码它们并比较它们的相似性。这是一项更为复杂的计算机视觉任务。
Definitely not. MySQL has no idea what the bytes in your
BLOBcolumn mean -- it doesn't even know that they're images, let alone how to decode them and compare them for similarity. That's a far more complex computer vision task.