uBois <[EMAIL PROTECTED]>:
> At 1:16 +0100 11/3/05, John thegimper wrote:
> >Is it possible to specify and IF statement or IGNORE statement when
> >useing LOAD
> >DATA?
> >Example
> >
> >SET price = IF PRICE(< 20) THEN IGNORE
> >SET price = IGNO
Is it possible to specify and IF statement or IGNORE statement when useing LOAD
DATA?
Example
SET price = IF PRICE(< 20) THEN IGNORE
SET price = IGNORE IF <20
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Ma
Why cant i get this to work? The name dont get replaced... :P
LOAD DATA
LOCAL
INFILE '/tmp/myfile.txt'
INTO TABLE cache
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name)
SET name = REPLACE(name, 'Coke', 'Pepsi');
-
FREE E-MA
Ok how can i mix boolean and regexp searches?
SELECT * FROM tbl WHERE MATCH (name) AGAINST ('TEST' IN BOOLEAN MODE) OR name
REGEXP 'TEST';
That dont work :(
Quoting [EMAIL PROTECTED]:
> John thegimper <[EMAIL PROTECTED]> wrote on 08/22/2005 04:55:46 AM:
>
ents.
------
I have done some searches on google and found several people wanting to do the
same... but no solutions.
Quoting John thegimper <[EMAIL PROTECTED]>:
> Is there still no solution for this? Every large searchengine works like
> this.
Is there still no solution for this? Every large searchengine works like this.
Quoting:
>
>
> Hi that works fine only now if a user puts + in front of a word that
> word
> becomes optional = OR?
> What i would like is the search to work exactly like before only that it
>
> defaults to AND inst
my host dont want to change the ft_min_word_len it´s now at 4 chars and i need
to do searches with only 2 chars.
Quoting Jasper Bryant-Greene <[EMAIL PROTECTED]>:
> John thegimper wrote:
> > Thanks so there is no operator that tells mysql that both words must
> match?
>
lt;[EMAIL PROTECTED]>:
>
> John,
>
> using 'one.*two|two.*one' would do it. :)
>
> regards,
> esv.
>
>
> --- John thegimper <[EMAIL PROTECTED]> wrote:
>
> > ok just figured out that if the database contains
> > "one and one is two&qu
ok just figured out that if the database contains "one and one is two"
and i use regexp to search for "one two" it will not match.
If i search for "one(.*)two" it will.
But how can i make it match if i search for "two one" ?
Quoting John thegimper <[EMAI
Here is another user with the same problem
http://forums.pcworld.co.nz/archive/index.php/t-34536.html
Maybe his explanation is better :)
Quoting John thegimper <[EMAIL PROTECTED]>:
> SELECT * FROM tbl WHERE item REGEXP 'SEARCHSTRING'
>
> Database holds:
> SAMSUNG
SELECT * FROM tbl WHERE item REGEXP 'SEARCHSTRING'
Database holds:
SAMSUNG IDE 40GB 7200RPM
Search for
SAMSUNG IDE 7200RPM = 0 RESULTS
SAMSUNG 40GB 7200RPM = 0 RESULTS
SAMSUNG +40GB +7200RPM = 0 RESULTS
SAMSUNG IDE 40GB = 1 RESULT
How do i need to change the SEARCHSTRING to use AND for each word
atabase | mysql -h
> yournewhost.som -u newuser -ppasswd newdatabase
>
> that's it !
> otherwise, yes dump/export.
>
> 2005/8/20, John thegimper <[EMAIL PROTECTED]>:
> > Is there an easy way to copy a table between two mysql servers? Or do
> i need to
> > export
Is there an easy way to copy a table between two mysql servers? Or do i need to
export and then import? I´m using php btw.
Thanks,
Johhn
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
For list arc
13 matches
Mail list logo
