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

2002-02-12 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)... =F6=F6=F6=F6hhhm forgot the correct sy=
ntax be
free to look into docs

SELECT * FROM skills,skillnames WHERE skill_name_id=3Did 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.



--=20

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


-
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-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