Search Function. Is this a Bug or what?

Question

Hi, i think there is a bug in the search function. Let me explain:

I have 1 post which contains the word "table" inside the title. When i try to perform a search and type "table" in the search field then i am getting 1 result and this is ok. But when i am typing "tabl" in the search field i am getting no results!!

Why the search looking for entire words only???

 

How can i make it display all results that CONTAINS the letters "tabl" or "tab" ?

 

Thanks in advance.

Comments

I have a similar issue, any fix for this please?
https://www.question2answer.org/qa/76963/q2a-search-for-words-with-apostrophe

Answer 1

Why the search looking for entire words only???

If you would search for parts of words like "tabl*", the mysql queries would need much more time. Especially if you have bigger data.

This would lead to a server time out, showing up in your browser.

Google "search engines algorithms, performance, implementation" to get more information on this topic.

Comments

How can i change it? It doesnt matter how much time will need the search function to perform a search. I dont have a large database. Could you please help me to change that ?

---

See qa-search-basic.php function process_search()

---

right now is  function process_search($query, $start, $count, $userid, $absoluteurls, $fullcontent)

What i have to change??

---

Any help please ???