bryndyment
03-22-2004, 05:09 PM
Hi,
Let's say I have two tables: TblCategory (with CatID and CatName) and TblProduct (with ProID and ProName). I want to od the equivalent of MySQL's fulltext search, but I want it to match CatName or ProName. I know the MySQL's fulltext search is only for single tables.
I'm sure jillions of people have solved this... ideas?
Let's say I have two tables: TblCategory (with CatID and CatName) and TblProduct (with ProID and ProName). I want to od the equivalent of MySQL's fulltext search, but I want it to match CatName or ProName. I know the MySQL's fulltext search is only for single tables.
I'm sure jillions of people have solved this... ideas?