Search in mysql db with result containing string with partial match

Question

I need to create a powerful search page for my website, I am using php & mysql.

I want to

get results with partial match. Eg, if I have stackoverflow in db but i have searched stacke so that should show up in the results.

I know about LIKE. I want to build a search like google which does take similar type words and searches that too.
get results by matching every word in the search string separately.

Do you want to use the full text search indexes of MySQL or an external search provider like Elastic Search or Solr? — tadman
– tadman, Commented Apr 26, 2013 at 15:12
@tadman - thanks for understanding the requirement buddy! I want to build a search like google which does take similar type words and searches that too. — rosinghal
– rosinghal, Commented Apr 26, 2013 at 20:13
You'll probably need to look at a search add-on for MySQL. The built in tools are decent enough if you're willing to put up with their limitations. The add-ons vary in capability, from better to fantastic. — tadman
– tadman, Commented Apr 26, 2013 at 20:40

Håkan · Accepted Answer · 2013-04-26 15:14:02Z

5

I don't know about "stacke" since that's not a substring of "stackoverflow". Maybe you meant "stacko"? In that case your query would be like

SELECT stuff FROM table WHERE field LIKE "stacko%";

answered Apr 26, 2013 at 15:14

Håkan

1866 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I know about LIKE. Please read the question again, i have modified it.