Mysql: Find rows where column value ends with a specific substring

Question

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`. Can anyone help me with this? I haven't found an answer here on SO.

Accepted Answer

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

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

Mysql: Find rows where column value ends with a specific substring

Solution

Problem