Ignore some text on a query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
powerPT
Forum Newbie
Posts: 14
Joined: Tue Apr 04, 2006 2:25 pm
Location: Portugal

Ignore some text on a query

Post by powerPT »

Guys, I have a query, it "catch" some text from table phpbb_posts_text (phpBB).
Well, what it return is everything, including the bbcode.

To know more properly, what it´s return:
Toyota is also said to be considering a plug-in capability as as standard feature. Currently, many Prius owners modify their cars for plug-in charging, but that can void the car’s warranty. In issue 904, the magazine reported the new 94 mpg Prius would offer an improved 0-62 mph time of under 10 seconds. Changes are also likely to come to the exterior of the new Prius. [url=http://www.leftlanenews.com/2006/06/06/ ... ve-94-mpg/]source[/url]Early last month, we reported that Toyota is considering using design to help differentiate its hybrid offerings from its other models.

In this quote, what I would like to "ignore" is the bbcode and it´s content(in this case a link)

Can anyone help me?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you'll have to "manually" filter that information out after pulling it from the database. phpbb does this with regex found in bbcode.php
Post Reply