Is there anyway to use RegExp in a field parameter? What would be great
is if I could do this,
SELECT Trim(Both RegExp '[a-z]' From value) as value_num, value
FROM num_test
WHERE value REGEXP 'N[1-999]';
The biggest problem is trying to find the position of where the number
starts in the string
On Friday 08 December 2006 01:57, Philip Mather wrote:
> You'll need a regex, see these...
> http://dev.mysql.com/doc/refman/4.1/en/pattern-matching.html
> http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html
> http://dev.mysql.com/doc/refman/4.1/en/regexp.html
Yes, you could us
Chris,
On Thursday 07 December 2006 16:34, Ed Reed wrote:
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHE
On Thursday 07 December 2006 16:34, Ed Reed wrote:
> Thanks for the quick reply Chris.
>
> It's close but it's a little off. Your example also returns all
> instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value
li
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
Do you know of a way to prevent that?
Thanks again
>>> Chris White <[EMAIL PROTECTED]> 12/7/06 3:11 PM >>>
On Thursday 07 Decemb
On Thursday 07 December 2006 14:57, Ed Reed wrote:
> Can someone help me with this?
quick hack, but it works from what you've stated:
mysql> create table num_test (id SERIAL PRIMARY KEY, value VARCHAR(256));
Query OK, 0 rows affected (0.07 sec)
mysql> insert into num_test (value) VALUES ('N400')
Can someone help me with this?
I have a text field that sometimes contains a number preceded with the
letter N. So it might look like this
A test N60
or
N45 someother text
or
This happened. N122, Then there was this.
I need to come up with a Select statement that can show me all the
