Jump to content

CaptainC

New Members
  • Posts

    6
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

CaptainC's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Would this regex be the way to go if I wanted to pull out the number value from this example?: <b><i>$456.50</i></b> And have preg_match pull out "456.50" ?
  2. 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?
  3. 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.
  4. 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.
  5. 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' ".
  6. 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.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.