CaptainC
-
Posts
6 -
Joined
-
Last visited
Never
Posts posted by CaptainC
-
-
I have an error with this statement:
[code]preg_match("[0-9]+\.?[0-9]*", $text_string, $match_array);[/code]
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: preg_match(): Unknown modifier '+' in ...[/quote]
I thought it had something to do with the slashed in php strings, but I have not been able to get it right.
Any thoughts? -
Ok found it. Just in case others need it, the location of the mysql regexp reference: [a href=\"http://dev.mysql.com/doc/refman/4.1/en/regexp.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/regexp.html[/a]
Thank again. -
That was perfect. Thank you very much. Do you know of any good sites for documentation/tutorials on MySQL REGEXP syntax? dev.mysql.com has references to the keyword, but its not very extensive at all especially with the formatting of the regular expression.
-
Thanks for the response. I was guessing at the sql version, its 4.x, i just didnt look up the exact number yet as I knew the functions were included in all 4.x releases. Also, I am working with a database that already exists, otherwise, I would have created the tables differently.
Otherwise, can CONCAT() take multiple (>2) parameters? Finally, how can I make sure that it does not match a "5" to a "15"? There are optional spaces surrounding a number, but I also want to specify: "no number before or after 'table2.t2_id' ". -
I am trying to incorporate REGEXP in an sql query (MySQL 4.3.x). The shortened database is as follows:
table1: t1_id, ids_in_table2
table2: t2_id, t2_data
In table1, the field 'ids_in_table2' represents a string of id numbers (integers only) separated by a space. For example "12 83 97 199". Those numbers are references to the field 't2_id' in table2. I want to obtain all the instances where 't2_id' appears in 'ids_in_table2' (my real example is more elaborate, but I simplified it to focus on what is important). My best query so far is:
[code]SELECT table1.ids_in_table2, table2.t2_id FROM table1, table2 WHERE table1.ids_in_table2 REGEXP '\s?'+table2.t2_id+'\s?'[/code]
This is returning a partially correct list. For example, it wille fail when it returns values where ids_in_table2 = "15 16" and t2_id = "5". It will return this set of data because it found the 5 in the string from ids_in_table2.
I would appreciate any help especially concerning how I am using the REGEXP keyword in mysql and the "+" operator as string catenation. I cannot find sufficient documentation and examples of this keyword.
preg_match Error
in PHP Coding Help
Posted
<b><i>$456.50</i></b>
And have preg_match pull out "456.50" ?