做一个简单的搜索

Question

I am doing a simple search, would the following query be correct?

mysql_query("SELECT * FROM products WHERE name LIKE'$searchquery' AND description LIKE'$searchquery'");

EDIT:

LIKE '$searchquery; this part needed a space, it turns out it was a syntax issue. I am quite intrigued by doing it the second way. As suggested by @yes123.

SELECT * FROM products WHERE MATCH(name,description) AGAINST ('$searchQuery')

I do this and I get:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/search.php on line 62

Answer 1

For searching purpouse you should use a FULL TEXT index. At that point your query becomes something like:

[...] WHERE MATCH(col1,col2) AGAINST ('your search') [...]

And please use PDO