Re: Regex with patterns in table field

<div class="bgcolor" style="background-color: ;"><div><div>Hi Chris,</div><div> </div><div>the query below works for me
-</div><div> </div><div>select* from TABLENAME where 'TEXT' ~ pattern;</div><div> </div><div>Thanks for
helping!</div><div> </div><div>Regards</div><div> </div><div>chrissmith writes: </div><div></div><div>> On 4/14/06,
pgdbwrote: </div><div>>> </div><div>>> </div><div>>> Hi Andreas, </div><div>>>
</div><div>>>strange but I don't see html from my original email received from the </div><div>>> mailing
list,hope this reply is ok:) </div><div>>> </div><div>>> If I'm not wrong, the example you've provided is
tryingto return matching </div><div>>> rows from multiple patterns and texts as inputs in the regex search.
</div><div>>></div><div>>> The text in regular expression have to be just a single string(with no white
</div><div>>>character) for my case. Matching should then be done with patterns from each </div><div>>>
row,returning the row(s) that contain matching regex pattern(s). Appreciate </div><div>>> any advice. Thanks.
</div><div>></div><div>> This page might be what you're after: </div><div>> </div><div>>
http://www.postgresql.org/docs/8.1/static/functions-matching.html</div><div>> </div><div>> -- </div><div>>
Postgresql& php tutorials </div><div>> http://www.designmagick.com/
</div><div></div><div></div></div></div><div>________________________________</div><div>FreePOP3 Email from <a
href="http://www.gawab.com"target="_blank">www.gawab.com</a></div><div>Sign up NOW and get your account
@gawab.com!!</div>