Re: Enum

2001-09-17 Thread Charlie Harrison 

Ann Myhre wrote:

Hi group

Access has a datatype (I don't remember the name) which is a kind of boleaen; it 
represents Yes/No, true or false. When I try to translate that creating a table in 
MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y 
then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result.
Anyone?


Use type `bool'. This is an alias for tinyint(1), with values 0 or 1.

Charlie






-
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: Fulltext search

2001-09-10 Thread Charlie Harrison 

Lorang Jacques wrote:

Hello,
This is the last time I will post this thread. Apparently nobody knows any
solution to this :

The Fulltext search only matches those rows who match
teh exact word, so if I search for bank, the query wont find banking.
(this would work with like '%bank%', but that is much slower). So is there
anything you can to make it also match those ??

I don't think you can make FULLTEXT do substring matches.

If LIKE is too slow, maybe try |INSTR|(str, substr) instead and see if 
it's any faster.


Thankx
Lorang Jacques
sql is mysql


-
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