Removing characters from a field - REGEXP???

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 need

RE: LOAD DATA INFILE Problem

just 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 PROT

LOAD DATA INFILE Problem

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 DA

MYSQL 4.0 in production?

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 beta

FULL TEXT results

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) AGAI

RE: Pictures in mysql

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 struct

FW: MS Access Links to Mysql

Many thanks to [EMAIL PROTECTED] for a work around to my question, here is the reply - as he/she cannot post to the list as their email server adds an attachment, preventing the post. Thanks again, John. --- Yes, I have had the same problem. >From what I can tell, the i

RE: Reset Auto Increment

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 +

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 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

Update Logging on Windows 2000 Service

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 ser

RE: Semi colons in text fields in update statement

ame error in VB, but wasn't in fact. So I think it all comes 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

Semi colons in text fields in update statement

Hello I'm trying to do the following: "Update tblCompany SET CoName='"tester"' WHERE CoID=109" But getting an error message I tried the escape character "\" like "Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" but get the same error This happens whether I use ADODB in VB or if