Problems with LIKE statement

[paulbradley]

I have a search box which users can enter a phrase and it searches for items LIKE what they enetered, using the following command:

SELECT product_name FROM products WHERE '$searchitem' LIKE product_name ORDER BY end_time

But this only seems to return items identical to product_name. Any ideas? Thanks in advance.

 

[ChrisHirst]

you need to add "wildcards" to the search term and reverse the order.

... WHERE product_name LIKE " . "'%" . $searchitem . "%'" . " ORDER...

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
Nightclub counting systems

So long, and thanks for all the fish.

 

[paulbradley]

That dosen't seem to help I'm afraid, it's only returning items which *exactly* match what i entered.

Thanks for the help so far.

 

[jpadie]

which rdbms are you using?

 

[jpadie]

sorry ... and are you using an abstraction layer?

 

[sylve]

Using mysql db, your query look like this in php:

$query = "SELECT product_name FROM products WHERE $searchitem LIKE '%$product_name%' ORDER BY end_time";

remove the '' near $searchitem but add them for $productname.

Tell us if it works!

 

[hos2]

SELECT product_name FROM products WHERE product_name LIKE '%$searchitem%' ORDER BY end_time

or

SELECT product_name FROM products WHERE '$searchitem' LIKE '%product_name%' ORDER BY end_time

otherwise I don't know what you mean ???

 

[paulbradley]

Wehay! that works - cheers!