Keyword search

[feri_soft]

How to create a keywords search which can search 1 in the title, 2 in the description.

Please help,desperately need a solution.  :-\

[dymon]

Provide please more details about the search.

[Barand]

SELECT * FROM tablename
WHERE (title LIKE '%$keyword%')
OR (description LIKE '%$keyword%')

[Daniel0]

To do Google-like searching ("bla3 bla1" -bla2 +bla3) you may use fulltext searching: [code]SELECT * FROM tablename WHERE MATCH (title,body) AGAINST ('"bla3 bla1" -bla2 +bla3' IN BOOLEAN MODE);[/code]

[feri_soft]

Bernard are you sure that SELECT * FROM tablename
WHERE (title LIKE '%$keyword%')
OR (description LIKE '%$keyword%') will find exactly the matches...because i dont want unneeded results.

[alpine]

To find exact matches, remove the percentage signs:
[code]

<?php

SELECT * FROM tablename WHERE (title LIKE '$keyword') OR (description LIKE '$keyword') // exact match

SELECT * FROM tablename WHERE (title LIKE '%$keyword%') OR (description LIKE '%$keyword%') // match somewhere in

SELECT * FROM tablename WHERE (title LIKE '$keyword%') OR (description LIKE '$keyword%') // exact match on "starting with"

SELECT * FROM tablename WHERE (title LIKE '%$keyword') OR (description LIKE '%$keyword') // exact match on "ending with"

?>

[/code]

[feri_soft]

Thanks