Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Weird Select

5:02 am on Jan 5, 2005 (gmt 0)

Full Member

10+ Year Member

joined:Apr 27, 2003
votes: 0

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.
12:04 pm on Jan 5, 2005 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 2

In MySQL you could use something like the CHAR_LENGTH [dev.mysql.com] string function.
SELECT column FROM table WHERE CHAR_LENGTH(column) < 300;

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members