Hi,
Can anyone suggest a good on-line source for information about MySQL Regular Expressions? I have an excellent book on MySQL, and it gives many examples, but it is not quite as comprehensive as I was hoping.
The root of my problems start with values in a column that have a start value and a stop value seperated by a dash ("-"
.
For example:
9-123
19-777
1-1450
0-7
(this data will NEVER contain negative numbers)
I am wanting to grab the number before the dash, and then grab the number after the dash (in seperate parts of my SELECT statement)...
I have found a LONG work around using MySQL commands like LENGTH, RIGHT, LEFT,...
I was hoping for a "cleaner" solution, and I was hoping to use RegExps like I would in Perl.
Thanks for your help finding a tutorial or in assisting me with my query.
Can anyone suggest a good on-line source for information about MySQL Regular Expressions? I have an excellent book on MySQL, and it gives many examples, but it is not quite as comprehensive as I was hoping.
The root of my problems start with values in a column that have a start value and a stop value seperated by a dash ("-"
.For example:
9-123
19-777
1-1450
0-7
(this data will NEVER contain negative numbers)
I am wanting to grab the number before the dash, and then grab the number after the dash (in seperate parts of my SELECT statement)...
I have found a LONG work around using MySQL commands like LENGTH, RIGHT, LEFT,...
I was hoping for a "cleaner" solution, and I was hoping to use RegExps like I would in Perl.
Thanks for your help finding a tutorial or in assisting me with my query.