GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Any mySQL/SQL experts around? (https://gfy.com/showthread.php?t=724933)

Tempest 04-17-2007 01:02 AM

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.

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 (Post 12265920)
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.


All times are GMT -7. The time now is 01:54 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123