![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| Hello, sorry for my terrible english, I've got a problem: in a mysql table like : id INT(11) auto_increment not null primary key, tab_title VARCHAR(20), tab_content BLOB 'tab_content' field may contain html code. Can I create a SELECT query which finds a text in 'tab_content' field and excludes html tags? For example : if I have to find : FFF it will find : <b>My name is FFF ...</b> it won't find : <font color="#FFFFFF">My name is Frank ....</font> Thanks in advance. | |||
| | #2 | ||
| fabmo schrieb: > Hello, > sorry for my terrible english, I've got a problem: > > in a mysql table like : > > id INT(11) auto_increment not null primary key, > tab_title VARCHAR(20), > tab_content BLOB > > 'tab_content' field may contain html code. > > Can I create a SELECT query which finds a text in 'tab_content' field > and excludes html tags? > no. You should store your data in a structured format if you need that or remove all HTML before storing the text. | |||
| Featured Websites | ||||
|
![]() |
| Tags: excluding, html, select, tags |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| select two conditions of a many to one | Dont Wantogetspammed | Database | 1 | 05-31-2007 8:44 PM |
| Select while in | Bill Y. Barool | Database | 2 | 05-31-2007 8:39 PM |
| Malicious HTML tags | Rich | Website Reviews And Website Questions | 0 | 05-28-2007 12:43 AM |
| Featured Websites | ||||
|