Re: Boolean searches on InnoDB tables?

At 02:54 AM 3/4/2006, Daevid Vincent wrote: I just discovered this: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Which states: "They can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow. " But then I'm kicked in the nuts because:

Re: boolean search on phrase*

ns" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]> Sent: Thursday, October 12, 2006 2:58 PM Subject: Re: boolean search on phrase Hello: I may be going out on a limb, as I missed part of the thread; nevertheless, have you tried regular expressions? As

RE: Boolean search on phrase*

y Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Visolve DB Team [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 12, 2006 4:55 AM > To: C.R.Vegelin; mysql@lists.mysql.com > Subje

Re: boolean search on phrase*

;[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]>; Sent: Thursday, October 12, 2006 11:05 AM Subject: Re: boolean search on phrase* Hi, Try with + and * fulltext boolean operators. For instance, MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MO

Re: boolean search on phrase*

ED]>; Sent: Thursday, October 12, 2006 4:08 PM Subject: Re: boolean search on phrase* Thanks ViSolve, So far I have tried the next alternatives, not giving me what I need: a) ... MATCH (Description) AGAINST('"olive oil"' IN BOOLEAN MODE) giving only "olive oil"

Re: boolean search on phrase*

rom: Visolve DB Team To: C.R.Vegelin ; mysql@lists.mysql.com Sent: Thursday, October 12, 2006 9:54 AM Subject: Re: boolean search on phrase* Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote ('"'), then the characters

Re: boolean search on phrase*

Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote ('"'), then the characters matches only rows that contain the phrase literally, as it was typed. Try removing quotes. Thanks ViSolve DB Team. - Original Message - From: "C.R.Vegelin" <[

Re: BOOLEAN search with asterisk as preceeding operand?

I wouldn't consider that a problem. If you want to search on contains or ends with, you can't use an index. Thus you should use LIKE. select * from table where field like "%searchtext%" That would give you the functionality you are looking for. How would you look up a word in the dictionary tha

Re: Boolean searches on InnoDB tables?

*MySQL Manual - Chapter 12.7.4. Full-Text Restrictions* says: *Full-text searches are supported for MyISAM tables only. * You could try to do what i did... with some overhead... I also had InnoDB tables for an application and also was in a great need of Full-Text Searches. I made a mirror MyISAM

Re: Boolean searches on InnoDB tables?

Daevid, - Original Message - From: ""Daevid Vincent"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, March 07, 2006 5:54 AM Subject: RE: Boolean searches on InnoDB tables? Osku is working on FULLTEXT for InnoDB. So, despite what th

RE: Boolean searches on InnoDB tables?

> Osku is working on FULLTEXT for InnoDB. So, despite what the documentation says: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Which states: "They can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow. " You're saying that InnoDB t

Re: Boolean searches on InnoDB tables?

Daevid, - Original Message - From: ""Daevid Vincent"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, March 04, 2006 9:54 AM Subject: Boolean searches on InnoDB tables? I just discovered this: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Which

Re: BOOLEAN Vs NON-Boolean

you are doing it correctly.. you should be able to sort by relevance. it know you can sort like that because my search engine does using boolean. Lee Denny wrote: Hello, I've just upgraded to 4.1 for boolean search facilities, but I think I may lose more than I 've gained. I just really nee

RE: Boolean searches

MY first post had html in it where I posted my indexin that I am using. URL UNIQUE 5451 URL expiresFlag INDEX 1 expiresFlag title FULLTEXT 1 title keywords body_1 FULLTEXT 1 body_1 body_2 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 8825

RE: Boolean search showing zero results in error

Thank you very much, that is a great help. Alisa -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: lundi 20 decembre 2004 22:06 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Boolean search showing zero results in error "keep" is a full-tex

Re: Boolean search showing zero results in error

"keep" is a full-text stopword, by default, which means it isn't indexed. You'll need a custom stopword list if you want "keep" to be indexed. See the manual for details . The default list of stopwords is in myisam/ft_static.c in a s

RE: Boolean Data Type in MySQL

MySql doesn´t support boolean data type. Try TinyInt unsigned, with two values: 0 False, 1 True. Regards, Rafa RE: Boolean Data Type in MySQL __ The NEW Netscape 7.0 browser is now available. Upgrade now! http

RE: Boolean Data Type in MySQL

Unless I am mistaken it's just converted to a tinyint datatype -=Bryan=- -Original Message- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:28 AM To: kayamboo; list mysql Subject: Boolean Data Type in MySQL Hi All Does MySQl Support Boolean Datatypes -Aru

Re: boolean-mode fulltext search: problems with +searchterm*

Hi! On May 17, Carl J Meyer wrote: > >Description: > It appears that MySQL can have trouble with a searchterm > in a boolean-mode fulltext index search which is both prefixed > with + and suffixed with *, when that searchterm is paired > with another required term. The empty set is returne

Re: boolean-mode fulltext search: problems with +searchterm*

Carl, Friday, May 17, 2002, 8:46:59 AM, you wrote: CJM> >Description: CJM> It appears that MySQL can have trouble with a searchterm CJM> in a boolean-mode fulltext index search which is both prefixed CJM> with + and suffixed with *, when that searchterm is paired CJM> with another require

RE: Boolean!

ENUM datatype might help you... See: http://www.mysql.com/doc/E/N/ENUM.html Gurhan -Original Message- From: T.Thiessens [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Boolean! Hello! Well their you have it! It's a mysql freakshow out

RE: Boolean!

> > How can I set the domain of a attribute to a boolean value? > > OK, I'm not entirely clear with your terminology, but I think > you're asking > "how do I define a field as a boolean"... > > MySQL doesn't provide a boolean datatype as such, but in my experience the > best way to handle it is t

RE: Boolean!

I use char(1) with 't' and 'f'. The JDBC-Driver I am using (mm.sql) recognizes this correctly as Boolean. Peter > -Original Message- > From: Jon Haworth [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 15, 2002 5:24 PM > To: 'T.Thiessens'

RE: Boolean!

Hi T., > How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking "how do I define a field as a boolean"... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to defin

Re: Boolean Fulltext in 4.0.2 bug

Hi! On Mar 22, Alexander Belyaev wrote: > Hi, > > I know, many fulltext bugs fixed last two weeks, thanks! > But this nice mysql4 feature are critical for us, we plan to use it in many > projects... and we test it again and again... :) > > My test case: > http://www.graphit.ru/fulltext402.tar.

Re: Boolean Fulltext in 4.0.2 bug

Hi, I know, many fulltext bugs fixed last two weeks, thanks! But this nice mysql4 feature are critical for us, we plan to use it in many projects... and we test it again and again... :) My test case: http://www.graphit.ru/fulltext402.tar.gz test.res - output from 4.0.2 cloned 2002-03-21. With

Re: Boolean Fulltext in 4.0.2 bug

Hi! On Mar 21, Alexander Belyaev wrote: > Hello, > > CREATE TABLE IF NOT EXISTS test ( > id mediumint(6) unsigned NOT NULL DEFAULT '0' , > txt text , > PRIMARY KEY (id) > ); > > #insert. 4 rows > > ALTER TABLE test ADD FULLTEXT findind (txt); > > select * from test where match(t

Re: Boolean Fulltext problems part III

Hi! On Feb 19, Alexander Belyaev wrote: > > Hello, > > Sergey, thanks for the patch, I applied it for 4.0.1 and seems like > mentioned bug closed. > > But I found new bug :) > > Strange, but the query WORKS AS EXPECTED without fulltext index! > > The results for 4.0.1 with latest fulltext p

Re: Boolean operators doesnt work in fulltext searched (4.0.1)

You need to add the 'IN BOOLEAN MODE' modifier. Try: SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database +tutorial' IN BOOLEAN MODE); and SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database -tutorial' IN BOOLEAN MODE); --jeff - Original Message - From:

RE: Boolean column type?

> Is a boolean column type possible in mysql? If not, what's the > most common > column type for true/false (or true/false/null) flags? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_16_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/m

Re: Boolean column type?

Hello Christopher! On Tue, 13 Nov 2001, Christian Stromberger wrote: > Is a boolean column type possible in mysql? If not, what's the most common > column type for true/false (or true/false/null) flags? TINYINT works fine, set it to a 0 or a 1. It takes just one byte. Any programming language

RE: BOOLEAN Variable

Shomaail [SMTP:[EMAIL PROTECTED]] wrote: > > I am using MySQL 3.23.22-beta > > pls tell is there any way to define boolean variable in this db > > what is the BOOL for ? > > declaring a var BOOL make it TINYINT(1)! but not boolean > > > > thanks > > Shomaai --- Noel Clarkson <[EMAIL PROTECTED]> w

RE: BOOLEAN Variable

Hi there, My understanding is that there is no BOOL type in MySQL but BOOL is allowed in create table statements (or alter table etc) for compatibility with other databases (but MySQL uses a tinyint for a bool because it doesn't have bool). You can use a tinyint and say that 0 is false 1 is t

Re: Antwort: Re: boolean type

So sprach Robert Vetter am Thu, Mar 01, 2001 at 04:55:34PM +0100: > 1 or 2 bytes, depending on the number of enumeration values (65535 > values maximum). I've read this in the _MANUAL_ ! Heh, okay, thanks *G* Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (

Re: Antwort: Re: boolean type

[EMAIL PROTECTED] wrote: > > On 01.03.2001 13:51:58 Robert Vetter wrote: > > > ENUM("no","yes") > > I always wondered: How much space does this take? 1 or 2 bytes, depending on the number of enumeration values (65535 values maximum). I've read this in the _MANUAL_ ! Robert

Re: boolean type

Blaz Grapar wrote: > > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest >to the boolean type ENUM("no","yes") - Before posting, please check: http://www.mysql.com/manual.php (the manu

Re: Boolean Puzzler - What is the parser doing?

Hello. On Sun, Feb 18, 2001 at 07:43:25PM -0600, [EMAIL PROTECTED] wrote: [...] > When I execute the following query: > > select acts.resolution, title from acts, acts_text > where acts.resolution=acts_text.resolution and > words like "% china %" or words like "% japan %"; > > I g

Re: Boolean Datatype

: "Oson, Chris M." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 07, 2001 4:45 Subject: Re: Boolean Datatype > I can't do that for 2 reasons : > 1] 'True' and 'False' are reserved words in ASP > 2] 'True' would th

Re: Boolean Datatype

MAIL PROTECTED]> Sent: Tuesday, February 06, 2001 3:56 PM Subject: Re: Boolean Datatype http://www.mysql.com/doc/A/d/Adding_functions.html Could this help him out? Creating a User Defined Function? Gregg - Original Message - From: Russ Davies <[EMAIL PROTECTED]> To: Matt Friedman &

Re: Boolean Datatype

y 06, 2001 3:42 PM Subject: Re: Boolean Datatype Enum would allow me to have two values such as 'True' and 'False' ? The problem is when I pass in this SQL statement to mySQL: INSERT INTO tableName (fieldName) VALUES (True); -mySQL does not recognise the word True - it w

Re: Boolean Datatype

al Message - From: "Oson, Chris M." <[EMAIL PROTECTED]> To: "Russ Davies" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype > Maybe, but you could define a constant.. > > CONS

Re: Boolean Datatype

to be for an ENUM data type? Russ Davies - Original Message - From: "Vivek Khera" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 9:09 PM Subject: Re: Boolean Datatype > >>>>> "RD" == Russ Davies <[EMAIL

RE: Boolean Datatype

ssage- > From: Russ Davies [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 06, 2001 2:44 PM > To: Oson, Chris M.; [EMAIL PROTECTED] > Subject: Re: Boolean Datatype > > > Thanks for the suggestion, but this would still mean converting the data > type from within ASP (the

Re: Boolean Datatype

hanks in advance for your efforts, Russ Davies - Original Message - From: "Matt Friedman" <[EMAIL PROTECTED]> To: "Russ Davies" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 9:11 PM Subject: Re: Bo

Re: Boolean Datatype

> "RD" == Russ Davies <[EMAIL PROTECTED]> writes: RD> Thanks for the suggestion, but this would still mean converting the data RD> type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I person

Re: Boolean Datatype

: "Oson, Chris M." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 12:45 PM Subject: Re: Boolean Datatype > I can't do that for 2 reasons : > 1] 'True' and 'False' are reserved words in ASP > 2] 'True' would

Re: Boolean Datatype

o: "Russ Davies" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype > Maybe, but you could define a constant.. > > CONST TRUE "T" > CONST FALSE "F" > > INSERT INTO logInf

RE: Boolean Datatype

001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still i

Re: Boolean Datatype

From: "Oson, Chris M." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype > Why not try using ENUM? > > http://www.mysql.com/doc/E/N/ENUM.html > > You could setup

RE: Boolean Datatype

Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM