php & mysql hrlp for search form

[UnknownPlayer]

I need help with search form.

When someone enter in search form "dota allstars", if in mysql is no such a thing like that at table "news", i wonna to find similar data, how can i do that?

[AbraCadaver]

I need help with search form.

When someone enter in search form "dota allstars", if in mysql is no such a thing like that at table "news", i wonna to find similar data, how can i do that?

 

What do you consider "similar data"?

[UnknownPlayer]

Something like "dota" then "allstars"

I just need to know how other search engines work :S

[AbraCadaver]

Something like "dota" then "allstars"

I just need to know how other search engines work :S

 

You can use LIKE and the wildcard % or better would be full-text searching: http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

[UnknownPlayer]

Can u give me example of full-text searching please ?

[AbraCadaver]

Can u give me example of full-text searching please ?

 

Look at the link I posted.  There are examples all in there.  You have to set the fields as FULLTEXT in the table definition:

 

CREATE TABLE articles (
    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    ->   title VARCHAR(200),
    ->   body TEXT,
    ->   FULLTEXT (title,body)
    -> ) ENGINE=MyISAM;

 

Then something like:

 

 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('dota allstars')