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
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 use a
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
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
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
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 December 2006
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
like