I can do this and receive 30 rows:
products.product_descr LIKE '%’%'
OR products.short_description LIKE '%’%'
OR products.product_active_ingr LIKE '%’%'
OR products.product_actives LIKE '%’%'
But I need a update one. For instance, the field product_descr contains this:
Able to hold skin’s moisture in balance through stressful shifts in humidity, like steamy exteriors and interiors parched by air conditioning. Never go thirsty again.
Notice the smart quote in skin's.