• I want to search some posts which contain characters **awk -v **in my wordpress.

    1.to search it with mysql select command.

    select guid,post_title from wp_posts where post_content like ‘%awk%-v%’;
    +—————————–+—————————————+
    | guid | post_title |
    +—————————–+—————————————+
    | https://hwy.local/wp/?p=3323 | 文本处理工具awk |
    | https://hwy.local/wp/?p=3330 | 格式化a链接:添加属性和值 |
    | https://hwy.local/wp/?p=3339 | 文本处理工具awk |
    +—————————–+—————————————+
    3 rows in set (0.06 sec)

    table1
    select with sql

    2.to search it in search posts.
    table2
    select in search post

    Why the two search results are totally different?
    It is verified that all the search results in search posts form are wrong ,all the the search results with sql command are right.
    Why the search results are wrong in search posts form?
    All the four search results searched in search posts form opened ,none of them contain characters both **awk** and **-v**.

    [table1]: https://i.stack.imgur.com/I5qNC.png
    [table2]: https://i.stack.imgur.com/H4KrJ.png

    • This topic was modified 7 years, 7 months ago by elearn2014.
    • This topic was modified 7 years, 7 months ago by elearn2014.
Viewing 1 replies (of 1 total)
  • Thread Starter elearn2014

    (@elearn2014)

    It’s no use to paste it in pre tag in text mode.
    Please try it with my code.txt file to verify .

    • This reply was modified 7 years, 7 months ago by elearn2014.
Viewing 1 replies (of 1 total)
  • The topic ‘Why the search results are wrong in search posts form?’ is closed to new replies.