Weird Select

[bobnew32]

I have a HUGE forum and i'm trying to skim the fat by delete messages in the database less than 300 characters long. Is there any way at all to somehow do a select query? It can be byte size as well, or anything related to this. Thx.

[coopster]

In MySQL you could use something like the CHAR_LENGTH [dev.mysql.com] string function.

SELECT column FROM table WHERE CHAR_LENGTH(column) < 300;