Welcome to WebmasterWorld Guest from 54.163.61.66

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
posts:243
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)

Administrator

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

joined:July 31, 2003
posts:12548
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