Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
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 > >

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
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 >> >> "

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Martijn Tonies
> >> 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

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
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

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
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

Re: [Fwd: search issue] mysqlimport problem with , inside fields

2007-02-19 Thread Michael Raven
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-

RE: [Fwd: search issue]

2007-02-13 Thread afan
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

RE: [Fwd: search issue]

2007-02-13 Thread Jerry Schwartz
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

Re: [Fwd: search issue]

2007-02-13 Thread Lars Schwarz
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