blocks|key|2914688|text|我本来是说：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2914689|"SELECT+`answer`+FROM+`faq`+WHERE+(`answer`+LIKE+'%25".strip_tags($searchKey)."%25'")|code-block|syntax|javascript|2914690|但是现在，这是由于评论而添加的内容。|2914691|那为什么不这样做呢？|2914692|$query+=+mysql_query("SELECT+`answer`+FROM+`faq`+WHERE+(`answer`+LIKE+'%25$searchKey%25'");
while+($result+=+mysql_fetch_object($query))+{
++++$newStrippedItem+=+strip_tags($result->columnItemName);
}|2914693|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I originally said:

<pre><code>"SELECT `answer` FROM `faq` WHERE (`answer` LIKE '%".strip_tags($searchKey)."%'")
</code></pre>

but now this is what has been added due to comments..

Why not do something like this then?

<pre><code>$query = mysql_query("SELECT `answer` FROM `faq` WHERE (`answer` LIKE '%$searchKey%'");
while ($result = mysql_fetch_object($query)) {
 $newStrippedItem = strip_tags($result-&gt;columnItemName);
}
</code></pre>

blocks|key|3773573|text|您需要做的是使用PHP函数htmlentities(answer)。它将以纯文本形式显示HTML标记。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3773574|希望能帮上忙|3773575|布拉姆|3773576|entityMap^0|8|3|D|K|18|4|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|K|$]]

What you need to do is use the <code>PHP</code> function <code>htmlentities(answer)</code>.
It will display the <code>HTML</code> tags as plain text.

Hope it helps,

Bram

blocks|key|2914748|text|货架上没有这样的功能。虽然可以编写，但编写一个“简化”的答案版本并对其运行全文匹配会更有表现力。毕竟，搜索将在由mysql_strip_tag函数生成或存储在ANSWER_SIMPLE列中的条带_tag‘’ed版本的答案上进行，逻辑是相同的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2914749|在搜索时，您可以使用带条标签、删除噪声词和小写SearchQuery，然后在ANSWER_SIMPLE中查找您的SimplifiedSearchQuery。您还可以使用其他技巧，例如在存储和搜索之前将所有单词转换为Soundex格式(可选吗？)“相似之处”。|2914750|另一种可能是将SearchQuery块成单个单词并分别搜索它们。因此，如果由于有“但{em}I{/em}是您的{em}Queen{/em}!”(其中找不到SearchQuery“您的皇后”)，则可以搜索的匹配项，即“/em”和"Queen“。这将导致误报，但允许您使用当前的数据库而不求助于剥离的辅助列或表。|offset|length|style|BOLD|2914751|entityMap^0|0|0|2T|1H|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

There is no such function off the shelf. While it could be written, it would be much more performant to prepare a "simplified" version of ANSWER and run a fulltext matching on that one. After all, the search would take place on a strip_tag'ed version of ANSWER: be it is generated by a mysql_strip_tag function or stored in a ANSWER_SIMPLE column, the logic is the same.

On searching, you e.g. strip tags, remove noise-words, and lowercase SearchQuery, then look for your SimplifiedSearchQuery within ANSWER_SIMPLE. You might also do other tricks such as convert all words to their Soundex form before storing, and search (optionally?) for "similarities".

Another possibility is to chunk SearchQuery into single words and search them separately. So if the HTMLised Answer does not match because you have, say, "But {em}I{/em} am your {em}Queen{/em}!", where the SearchQuery "your Queen" won't be found, you can search for matches for both "your" and "Queen". This will entail false positives, but allows you to employ your current database without resorting to a stripped ancillary column or table.

blocks|key|3773806|text|嗯，我知道这很古老，但是，我认为您可以通过在mysql上创建这个函数来解决问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3773807|DELIMITER+%7C
DROP+FUNCTION+IF+EXISTS+plain_text+%7C
CREATE+FUNCTION+plain_text(+Dirty+text+)
RETURNS+text
DETERMINISTIC+
BEGIN
++DECLARE+iStart,+iEnd,+iLength+int;
++++WHILE+Locate(+'<',+Dirty+)+>+0+And+Locate(+'>',+Dirty,+Locate(+'<',+Dirty+))+>+0+DO
++++++BEGIN
++++++++SET+iStart+=+Locate(+'<style>',+Dirty+),+iEnd+=+Locate(+'</style>',+Dirty);
++++++++IF+iEnd+>+0+THEN
++++++++++++BEGIN
++++++++++++++++SET+iLength+=+(+iEnd+-+iStart)+%2B+12;
++++++++++++END;
++++++++ELSE
++++++++++++BEGIN
++++++++++++++++SET+iStart+=+Locate(+'<',+Dirty+),+iEnd+=+Locate(+'>',+Dirty,+Locate('<',+Dirty+));
++++++++++++++++SET+iLength+=+(+iEnd+-+iStart)+%2B+1;
++++++++++++END;
++++++++END+IF;
++++++++IF+iLength+>+0+THEN
++++++++++BEGIN
++++++++++++SET+Dirty+=+Insert(+Dirty,+iStart,+iLength,+'');
++++++++++END;
++++++++END+IF;
++++++END;
++++END+WHILE;
++++RETURN+Dirty;
END;
%7C
DELIMITER+;|code-block|syntax|javascript|3773808|此函数移除所有html标记和<style></style>标记之间的所有内容。|3773809|然后，您可以这样执行查询：|3773810|SELECT+plain_text(ANSWER)+as+plain_t+FROM+FAQ+HAVING+(plain_t+LIKE+'%25".$searchKey."%25')|3773811|entityMap^0|M|5|0|0|E|F|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

Well, I know this is old but, I think you could solve your problem by creating this function on <code>mysql</code>:

<pre><code>DELIMITER |
DROP FUNCTION IF EXISTS plain_text |
CREATE FUNCTION plain_text( Dirty text )
RETURNS text
DETERMINISTIC 
BEGIN
 DECLARE iStart, iEnd, iLength int;
 WHILE Locate( '&lt;', Dirty ) &gt; 0 And Locate( '&gt;', Dirty, Locate( '&lt;', Dirty )) &gt; 0 DO
 BEGIN
 SET iStart = Locate( '&lt;style&gt;', Dirty ), iEnd = Locate( '&lt;/style&gt;', Dirty);
 IF iEnd &gt; 0 THEN
 BEGIN
 SET iLength = ( iEnd - iStart) + 12;
 END;
 ELSE
 BEGIN
 SET iStart = Locate( '&lt;', Dirty ), iEnd = Locate( '&gt;', Dirty, Locate('&lt;', Dirty ));
 SET iLength = ( iEnd - iStart) + 1;
 END;
 END IF;
 IF iLength &gt; 0 THEN
 BEGIN
 SET Dirty = Insert( Dirty, iStart, iLength, '');
 END;
 END IF;
 END;
 END WHILE;
 RETURN Dirty;
END;
|
DELIMITER ;
</code></pre>

This function removes all the html tags and everything that is between <code>&lt;style&gt;&lt;/style&gt;</code> tags.

Then you could do your query like this:

<pre><code>SELECT plain_text(ANSWER) as plain_t FROM FAQ HAVING (plain_t LIKE '%".$searchKey."%')
</code></pre>

I have the following sql query in my code:

<pre><code>SELECT ANSWER FROM FAQ WHERE (ANSWER LIKE '%".$searchKey."%')
</code></pre>

Where ANSWER might contains html &amp; style tags also which makes the above query to retrieve nothing though the plain text matches. I am using Symfony 1.1 and the above query resides in <code>faq.php</code> file.

So can anybody suggest how can i overcome this problem?

mysql inbuilt function to strip off tags

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我的代码中有以下sql查询：SELECT ANSWER FROM FAQ WHERE (ANSWER LIKE '%".$searchKey."%')其中，答案可能包含html &样式标记，这使得上面的查询在纯文本匹配的情况下不会检索任何内容。我使用的是Symfony 1.1，上面的查询位于faq.php文件中。所以，...

问mysql内置函数以剥离标记
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql内置函数以剥离标记EN