Hello
Does anybody have experience with this problem ?
I need to index in fulltext also words like for example "D.O.M.",
etc. In this release mysql doesnt support it.
I need it, cause i need to search also in company names.
Does anybody have any idea how to do it ?
regards
ddd
Hello
Does anybody have experience with this problem ?
I need to index in fulltext also words like for example "D.O.M.",
etc. In this release mysql doesnt support it.
I need it, cause i need to search also in company names.
Does anybody have any idea how to do it ?
regards
ddd
__
Hello.
On Mon, May 27, 2002 at 10:31:52AM -0700, [EMAIL PROTECTED] wrote:
> Is this approach still of use if many more tables are
> added?
As I said (in the not-quoted part) "[This] is the standard approach
for implementing a M to N relationship."
> so basically you create a lot of 'relations'
Hi.
On Mon, May 27, 2002 at 05:21:20PM +0200, [EMAIL PROTECTED] wrote:
> > CREATE TABLE places (
> > idp INT(8) NOT NULL,
>
> Contex: SQL, database
>
> Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer?
That is an 4 byte integer with an supposed display-w
Is this approach still of use if many more tables are
added?
so basically you create a lot of 'relations' tables to
store key relations rather than store the relation in
each table?
olinux
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> If FULLTEXT indexes are out of question, wha
> CREATE TABLE places (
> idp INT(8) NOT NULL,
Contex: SQL, database
Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer?
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi.
If FULLTEXT indexes are out of question, what your suggestion is the
way to go. Although I would usually use an additional table:
CREATE TABLE places (
idp INT(8) NOT NULL,
place CHAR(32), /* Ex: "New York" */
PRIMARY KEY(idp)
);
CREATE TABLE tokens (
We have an application that needs to index every word (token) in a name,
separately.
Ex: "New York" must be indexed under "New" and "York".
One solution is to create an auxiliary table, extract the tokens one word
at a time, and cross-reference to the key of the original table.
Ex: CREATE TAB