MySQL:查找列值以特定子字符串结尾的行 [英] Mysql: Find rows where column value ends with a specific substring

问题描述

我有一个列url，其中所有值都是url.我正在尝试更新其他列的值，无论上述url以.pdf结尾.

I have a column url where all the values are urls. I'm trying to update the value of a different column where-ever the aforementioned url ends with .pdf.

有人可以帮我吗?在SO上，我还没有找到答案.

Can anyone help me with this? I haven't found an answer here on SO.

推荐答案

我可能会过于简化...但是根据您的描述，

I might be oversimplifying... but based on your description, would LIKE solve your problem?

UPDATE YourTable
SET DifferentColumn = 'NewValue'
WHERE Url LIKE '%.pdf'

这篇关于MySQL:查找列值以特定子字符串结尾的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！