this is a small sample of the data:
short_desc
| long_desc
----------------------------------------------------------+------------------------------------------------------------------------CHICKEN,BROILERS
ORFRYERS,LEG,MEAT&SKN,CKD,FRIED,BATTER | Chicken,
broilers or fryers, leg, meat and skin, cooked, fried, batter
Is the best method of search through this data full text search via
tsearch or some other method. I'm running version 8.3
say I want to search for chicken skin?
Thanks for the advice,
J