PHP and Mysql search engine

[kenny873]

i am going to write a search engine for my website in PHP and Mysql...anyone know a good start for me to delve into? The search will be like the one in this forum...

[sissy]

hi there,

well you have 2 choices really u can use either

SELECT * FROM table WHERE field LIKE '%$keyword%'

which is ok but will find too much garbage

better to use FULL TEXT as its quite accurate

SELECT *, MATCH(field) AGAINST ('$keyword') AS score FROM table WHERE MATCH(field) AGAINST('$keyword')

Much better result 🙂

hope that helps