Istvan Hubay Cebrian wrote:
>
> Hi everyone,
>
> I revert to this mailing list to ask for help accomplishing a specific
> task. I'll try to explain as best I can.
>
> Say I have a DB named... well... "database1", this db has the following
> tables:
>
> pt_table1
> pt_table2
> pt_table3
>
>
Martijn Tonies wrote:
>
>
>> >> Anyway of accomplishing this? Ideally without having to state each of
> the
>> >> tables names. And also that this would work so that you could only
>> > duplicate
>> >> tables that have a certain prefix, so: duplicate only tables that
>> start
>> > with
>> >> "
> >> Anyway of accomplishing this? Ideally without having to state each of
the
> >> tables names. And also that this would work so that you could only
> > duplicate
> >> tables that have a certain prefix, so: duplicate only tables that start
> > with
> >> "pt_" and change prefix to "es_" for examp
Martijn Tonies wrote:
>
> Hi,
>
>> I revert to this mailing list to ask for help accomplishing a specific
> task.
>> I'll try to explain as best I can.
>>
>> Say I have a DB named... well... "database1", this db has the following
>> tables:
>>
>> pt_table1
>> pt_table2
>> pt_table3
>>
>> What
Chris McKeever-2 wrote:
>
> On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote:
>>
>> Hi everyone,
>
>>
>> Say I have a DB named... well... "database1", this db has the following
>> tables:
>
>> What I want to do is copy each of the tables (exactly as they are,
>> including
>> primary
Scott Hamm wrote:
>
> Line 48:
>
> "48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 >
> [SYN,
> ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460"
>
Is the line 48 is different than other lines?
--
View this message in context:
http://www.nabble.com/mysqlimport-problem-with-%2C-
Right. And "+cap" will not find "caps" - whats downside too.
Though, my marketing director (who is in charge for this) will rather
acept that then ANY word that contains "cap", as you mentioned.
:)
But, Lars was right, the problem was in ft_min_word_len. It's by default 4
and I have to change to 3
Don't forget that LIKE "%cap%" will find "captain", "recapture", and
anything else that has the substring "cap" in it. Your Boolean match against
"+cap" will only find the word "cap". Make sure that's what you want.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmi
hi afan,
depending on your mysql conf you have a minimum word length. check
your config for:
ft_min_word_len
and change it to 3.
hth: lars
On 2/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hi to all!
I'm trying to get some products from products table using fulltext search
but someth