DELETE row based on the column value

excel, oracle11g, sql

Solution

Try this on Database

DELETE FROM TABLE 
WHERE UPPER(COLUMN) LIKE '%.WAV' 
      OR UPPER(COLUMN) LIKE '%.GIF' 
      OR UPPER(COLUMN) LIKE '%.JPEG'

Problem

Is there a way for me to delete rows based on the value it contains? For example, I have a table with values in one column containing a URL value, for example, /uk/quitclock/om2.asp /uk/quitclock/om666.wav Here, I need to delete rows with suffixes ending with WAV, GIF, or JPEG. How do I do that? If it's not possible, then is there any formula in excel that can help me do it?

Original source