Hello folks
Can anyone tell me an easy (1 SQL statement) to strip out non-alpha-numeric
characters from a field please, using SQL in MYSQL (ver 3 or 4)
eg.
'this house' this house
-123 house 123 house
I want to keep spaces, alpha chars and numerics, but everything else needs
Stupid problem this one no doubt.
I have a find in mysql\bin called words.txt
The file contains tab separated values with a newline character at the end:
225 20 Residence 73.563.580 187.5
225 20 Planibel195.5 63.579.5289
When I do
LOAD
writing Chr(13) at the
end of the line, and it works.
Hope that helps somebody else, just took me HOURS to figure it out.
Well, I will remember it next time!!!
Bye for now
-Original Message-
From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]]
Sent: 19 January 2002 20:47
To: [EMAIL PROTECTED
Peter
I suggest getting hold of the MyODBC drivers (you'll find reference to it in
the mysql manual)
Once installed you can attached to mysql tables in MS Access, then use the
report wizard in there to create your labels or if you are more confortable
in word you can open the access mdb file
Hi folks
I really need to use some of the new features of version 4, particularly the
UNION joins.
Has anyone had any experience with using the UNION, does it work ok and
fast?
Also, could you indicate your confidence level with regard to running ver
4.0 in production even though it's only
Hi
Having a few weird things with the FULL text Match, it's bringing back
records where there is definitely no match but the score is above 1.
Using the following SQL:
SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham
manga') AS score FROM tblText WHERE MATCH (pagetext)
Yes this is what we're doing.
Just put the pathname to the file into a VarChar field.
As for using the web to add them, I would suggest using ASPUpload(if you are
using ASP), or other similar utility, which allows you to create an upload
form then stores the uploaded file into a directory
I just saw this in the manual and think it can do what you need:
It's an option of the myisamchk program
--set-auto-increment[=value]
Force auto_increment to start at this or higher value. If no value is given,
then sets the next auto_increment value to the highest used value for the
auto key +
-
From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 3:44 PM
To: mysql
Cc: johnlucas
Subject: MS Access Links to Mysql
Hello again folks
I am using MS Access as the front end to my database, but after a while
of
use, I get a prompt as follows, when I try to close
Hello
I need to setup update logging for Mysql running on Windows 2000, I read in
the manual that this cannot be done when you are using mysql as a service
(as any startup parameters are ignored).
Ideally I would like to do this, so if the machine is restarted mysql starts
automatically as a
Hello again folks
I am using MS Access as the front end to my database, but after a while of
use, I get a prompt as follows, when I try to close a table in datasheet
view or when I try to close a form:
The action will reset the current code in break mode {blah blah blah}
Then I have to choose
Hello
I'm trying to do the following:
Update tblCompany SET CoName='quot;testerquot;' WHERE CoID=109
But getting an error message
I tried the escape character \ like
Update tblCompany SET CoName='quot\;testerquot\;' WHERE CoID=109
but get the same error
This happens whether I use ADODB in
down to a DBTools problem, but I could be wrong ( I
often am!)
Thanks again for people's advice.
John.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 7:15 PM
To: [EMAIL PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
Subject: RE: Semi
13 matches
Mail list logo