I'm having some problems with something that should be very simple indeed.
first of all I've a table called `bu_companies` with 23 columns with various information about the company...
basically I want some of the fields to be searchable via a fulltext search, so I set the table up as MyISAM so I can create a fulltext index
and then ran this query
Code: Select all
ALTER TABLE `bu_companies`ADD FULLTEXT(`company_name`, `description`);I have two records in the database:
one with a company_name of `h3omedia` another with `alaska design`
if i run eithe rof these queries they return 0 rows.
Code: Select all
SELECT * FROM `bu_companies`
WHERE MATCH(`company_name`) AGAINST ('alaska')Help would be very much appreaciated
