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

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%'", b