Search MySQL table for a kind of results

Question

Hello, How can I search within a MySQL table for results ending in anything except ".jpg"? Thanks.

Answer 1

SELECT  *
FROM    mytable
WHERE   myfield NOT RLIKE '\\.jpg$'

Answer 2

You don't need to involve regular expressions, you can just do:

SELECT my_fields
FROM my_table
WHERE my_field NOT LIKE '%.jpg'