SELECT 
  pd.product_id 
FROM 
  cscart_product_descriptions AS pd 
WHERE 
  pd.lang_code = 'en' 
  AND (
    pd.product LIKE '%The%' 
    OR pd.full_description LIKE '%The%' 
    OR pd.meta_keywords LIKE '%The%'
  ) 
LIMIT 
  5

Query time 0.00020

Result

product_id
7
11
13
20
26