Re: finding count of spaces in a string

2007-09-04 Thread dpgirago
> [EMAIL PROTECTED] wrote: >> We have numerous identical tables with a varchar column that holds data >> like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch >> of integers with a single space as a separator. There _should_ be no more >> than 30 entries ( and 29 spaces ),

Re: finding count of spaces in a string

2007-09-04 Thread Francesco Riosa
[EMAIL PROTECTED] ha scritto: > We have numerous identical tables with a varchar column that holds data > like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch > of integers with a single space as a separator. There _should_ be no more > than 30 entries ( and 29 spaces ), but

Re: finding count of spaces in a string

2007-09-04 Thread Rolando Edwards
1 0 1 0 25 7 0 139 0 9' st) A; ++ | FieldCount | ++ | 13 | ++ 1 row in set (0.00 sec) - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, September 4, 2007 11:36:41 AM (GMT-0500) America/New_York Subject: fin

Re: finding count of spaces in a string

2007-09-04 Thread Jay Pipes
[EMAIL PROTECTED] wrote: We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spaces ), but sometimes th

Re: finding count of spaces in a string

2007-09-04 Thread Baron Schwartz
Hi, [EMAIL PROTECTED] wrote: We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spaces ), but sometim

finding count of spaces in a string

2007-09-04 Thread dpgirago
We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spaces ), but sometimes the system misfires and the