ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
Quoting Jigal van Hemert [EMAIL PROTECTED]:
Lindsey wrote:
Lets say the table
So wich is the recomended way to import alot of data several times a day to
mysql? I´m going to recive ~40 csv-files 3-4times a day which need to be
imported. Each file contains around 10.000-50.000 items.
My guess is to use LOAD DATA... BUT i only want to import the items with an ID-
number
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
-S*Y will return all.
-
FREE E-MAIL IN 1
--
Forwarded message:
From [EMAIL PROTECTED] Tue May 1 14:37:53 2001
Date: Tue, 1 May 2001 14:37:53 -0500
From: Christopher P. Lindsey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Dates not compared properly?
Message-ID: [EMAIL PROTECTED]
Mime-Version: 1.0
Content-Type: text/plain; charset=us
Howdy all...
I've run into a strange date problem as of midnight, May 1, 2001 on my
i686 Linux machine running mySQL 3.23.37.
For some reason, queries can no longer compare dates properly:
mysql select count(*) from hit where date NOW()-1135560;
+--+
| count(*) |