regex discussion are a little outside of the scope of this list, but I will offer an opinion: You can't do math, no matter how simple, in regular expressions. I have seen many try and fail.
While I am sure there are circumstances around how that data got that way, what you really need to do is use the database relationally and decompose that field into data structures instead of strings, then you can do pretty much anything you want. - michael dykman On Dec 9, 2007 12:53 PM, David Scott <[EMAIL PROTECTED]> wrote: > I have a field in a DB that contains something like > "lvlscore4:4493,lvlscore5:3232,lvlscore6:6128" > I need to select all records where the "lvlscore5:" is greater than 3000. > I think this can be done using REGEXP but I have read the docs and am non > the wiser for it. Can anyone point me in the right direction? > -- > Thanks > David Scott > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
