Tuesday, from Matt Rudderham:
> 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.
I must read this a while to understand... sql sql sql
This is, what you mean:
CREATE FULLTEXT INDEX name (name)... ööööhhhm forgot the correct syntax be
free to look into docs
SELECT * FROM skills,skillnames WHERE skill_name_id=id and
MATCH(name) AGAINST('YOUR SEARCHED SKILLS');
BTW: These tables are suboptimal. You can reduce them to one table. This
kind of parting the tables makes only sense, if you have 3 Billion not 300
records.
--
SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris
---------------------------------------------------------------------
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
