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:
&g
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 MIN
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 that
Chris
--
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]>
&
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(*) |
+---
