Any mySQL/SQL experts around? - GoFuckYourself.com

Tempest · 04-17-2007, 01:02 AM

Is there an "easy" way to grab all records where the number of spaces (or some other character, or even a strnig) in a specific field is > then a set number? eg: you you want to count the "words" in each sentence that's been stored in a field.

teksonline · 04-17-2007, 01:04 AM

maybe, might be easier to use php/mysql

using strlen, substr, substr_count etc

milambur · 04-17-2007, 01:21 AM

Quote:

Originally Posted by Tempest

Is there an "easy" way to grab all records where the number of spaces (or some other character, or even a strnig) in a specific field is > then a set number? eg: you you want to count the "words" in each sentence that's been stored in a field.

Take a look here:
http://dev.mysql.com/doc/refman/4.1/...functions.html

You should be able to solve it with regular expressions.

04-17-2007, 01:02 AM	#1
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	Any mySQL/SQL experts around? Is there an "easy" way to grab all records where the number of spaces (or some other character, or even a strnig) in a specific field is > then a set number? eg: you you want to count the "words" in each sentence that's been stored in a field.

04-17-2007, 01:04 AM	#2
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	maybe, might be easier to use php/mysql using strlen, substr, substr_count etc