Date: 11/02/05 (MySQL Communtiy)    Keywords: database

Big thanks to jsciv for the help in unfreezing my database after an unsuccessful FULLTEXT indexing!

Now, I have the following query:

SELECT product_id, name, description, title, manufacturer,
       warehouse_price, product_markup, supplier_markup, filename,
       thumbnail_width, thumbnail_height, sell_price, minimum_price,
       item_number, category_key
FROM product
INNER JOIN supplier
  ON supplier_key = supplier_id
INNER JOIN picture
  ON picture_key = picture_id
WHERE placement_fe = 1 AND
      product.active > 0 AND
      (name LIKE '%mini%' OR
       description LIKE '%mini%' OR
       title LIKE '%mini%' OR
       manufacturer LIKE '%mini%' OR
       product_id='mini' OR
       item_number='mini')

Source: http://www.livejournal.com/community/mysql/72112.html