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 so that the number by itself can be shown as returned field.
>>> Chris White <[EMAIL PROTECTED]> 12/8/06 8:08 AM >>> 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 regex and it would work, but if the format of N### is persistant and there are no false positives than I'd rather use that instead of regexes, which can an intensive operation. Also you might want to try: SUBSTR(value,2) instead of LIKE 'N%' just to see how they compare. If a regex is required, you could have something like: SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value x; where x is one of the following depending on the situation: REGEX('N[0-9]+$') REGEX('N[0-9]+') REGEX('N[0-9]{3}$') depends on how specific you want to get really. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
