Hello, I have two tables in my database as such: CREATE TABLE `skill_names` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) );
CREATE TABLE `skills` ( `skills_id` int(11) NOT NULL auto_increment, `member_id` int(11) NOT NULL default '0', `schooling` varchar(100) default NULL, `certifications` varchar(20) NOT NULL default '', `description` blob NOT NULL, `skill_name_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`skills_id`) ); I would like to make full text indexes of the skills table as well as the other tables in the database. My question is that I would like to be able to search for the Member_ID's that have a certain skill name. How would I accomplish this? Also, right now the database has about 300 records, the database runs on a Pentium 200 with 96Mb. Can it handle this not much traffic? Thanks. Matt Rudderham I am running MySQL 3.23.38 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
