products LIKE this one

[Guest]

is it possible to enter an addition where / like into this query:

select p.products_id,
													  p.products_image,
													  pd.products_name,
													  pd.products_description  
									  from " . TABLE_PRODUCTS . " p,
										   " . TABLE_MANUFACTURERS . " pc,
										   " . TABLE_PRODUCTS_DESCRIPTION . " pd
									  where pc.manufacturers_id = '" . $xsell_category . "' and
											pc.manufacturers_id = p.manufacturers_id and
											p.products_id != '" . $HTTP_GET_VARS['products_id'] . "' and
											p.products_id = pd.products_id and
											pd.language_id = '" . $languages_id . "' and
											p.products_status = '1'

 

to select product names that are similar?

if none exist, revert to default query?