FULL-TEXT Index / Searching Question

2002-02-11 Thread 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. 

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


-
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

Re: FULL-TEXT Index / Searching Question (fwd)

2002-02-08 Thread Alex Aulbach 


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

FULL-TEXT Index / Searching Question

2002-02-05 Thread 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. 

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