Find and Delete rows with less than 100 characters

phellstrand · #1 (**permalink**) 10-18-10, 18:39

Hi,

I'm working with a database that has one column that contains rows with verbatim (text). I want to delete each row that has less than 100 characters. How would I write this query?

Any help is appreciated!
Thank you,
Patrik

r937 · #2 (**permalink**) 10-18-10, 18:44

whoa, this is a tricky one

j/k

Code:

DELETE 
  FROM daTable
 WHERE LENGTH(daColumn) < 100

phellstrand · #3 (**permalink**) 10-18-10, 19:00

Awesome; thank you! Not easy for us non-techs

...
-P

Internet Services

Web Development

Digital Marketing

Consumer Tech