...@newcenturydata.com]
Sent: Friday, June 15, 2012 10:19 AM
To: mysql@lists.mysql.com
Subject: mysqldump not escaping single quotes in field data
My backups from a mysqldump process are useless, because the dump files
are not escaping single quotes in the data in the fields.
So, O'Brien kills
My backups from a mysqldump process are useless, because the dump files are not
escaping single quotes in the data in the fields.
So, O'Brien kills it - instead of spitting out
'O\'Brien'
it spits out
'O'Brien'
I don't see anywhere in the documentation about mysqldump where you can tweak
I have mysql 5.5.
I am able to use mysqldump to export data with quotes and the dump had
escape character as seen below
LOCK TABLES `ananda` WRITE;
/*!4 ALTER TABLE `ananda` DISABLE KEYS */;
INSERT INTO `ananda` VALUES
(1,'ananda'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi
quotes in field data
My backups from a mysqldump process are useless, because the dump files
are not escaping single quotes in the data in the fields.
So, O'Brien kills it - instead of spitting out 'O\'Brien'
it spits out
'O'Brien'
I don't see anywhere in the documentation about mysqldump
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with . I want to remove them.
Below is the snapshot :
*ID /URL
Country
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
I need to remove the quotes in text columns in a mysql table. It has
You could go with regexes - s/^(.*)$/1/ should do (in whatever syntax is
appropriate for the parser you're using); or you could go with something
On 11/3/2011 02:29, Adarsh Sharma wrote:
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with . I want to remove them.
Below is the snapshot :
*ID /URL Country Publication / Description ...and so
Thanks Johan,
I solved the problem by the below command :-
UPDATE website_master SET url= REPLACE( url,'','');
Thanks
Johan De Meersman wrote:
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
I need to remove the quotes in text columns in a mysql table. It has
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
UPDATE website_master SET url= REPLACE( url,'','');
Yep, that works fine, too, on condition that there are no quotes in the middle
of your value that need to remain where they are :-)
--
Bier met grenadyn
Is als
in PHP and a numeric field in the table,
I'll include the $id in single quotes in the PHP statement, so even if the
value of $id is null, alpha, or invalid (not numeric) it does not generate a
mysql syntax error. Otherwise, without the single quotes, the statement
would be:
INSERT into table VALUES
On Mon, Sep 19, 2011 at 07:47, Reindl Harald h.rei...@thelounge.net wrote:
what ugly style - if it is not numeric and you throw it to the database
you are one of the many with a sql-injection because if you are get
ivalid values until there you have done no sanitize before and do not here
what ugly style - if it is not numeric and you throw it to the database
you are one of the many with a sql-injection because if you are get
ivalid values until there you have done no sanitize before and do not here
It's a matter of opinion. I never said the data wasn't sanitized (it is).
Am 19.09.2011 16:55, schrieb Hank:
what ugly style - if it is not numeric and you throw it to the database
you are one of the many with a sql-injection because if you are get
ivalid values until there you have done no sanitize before and do not here
It's a matter of opinion. I never said
On Mon, Sep 19, 2011 at 18:11, Reindl Harald h.rei...@thelounge.net wrote:
it is not because it is clear that it is sanitized instead hope and pray
thousands of layers somewhere else did it - for a inline-query the best
solution, if you are using a framework you will never have the insert into
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
$M[username]=mysql_real_escape_string($username); // Everything that
goes into $M is escaped
$query=INSERT INTO table (username) VALUES
On Tue, Sep 20, 2011 at 01:11, Hank hes...@gmail.com wrote:
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
$M[username]=mysql_real_escape_string($username); // Everything that
goes into $M is
Am 20.09.2011 00:39, schrieb Dotan Cohen:
On Tue, Sep 20, 2011 at 01:11, Hank hes...@gmail.com wrote:
Best of both worlds:
$username=$_POST['username'];
// do some stuff with username here
$M=array(); // Array of things to be inserted into MySQL
I want to be sure that all variables in the query are escaped. I don't
trust myself or anyone else to do this to every variable right before
the query:
$someVar=mysql_real_escape_string($someVar);
But you're doing exactly that right before the query anyway with:
On Tue, Sep 20, 2011 at 02:09, Hank hes...@gmail.com wrote:
I want to be sure that all variables in the query are escaped. I don't
trust myself or anyone else to do this to every variable right before
the query:
$someVar=mysql_real_escape_string($someVar);
But you're doing exactly that
On Tue, Sep 20, 2011 at 01:48, Reindl Harald h.rei...@thelounge.net wrote:
i would use a samll class holding the db-connection with insert/update-methods
pass the whole record-array, lokk what field types are used in the table
and use intval(), doubleval() or mysql_real_escape-String
so you
On Tue, Sep 20, 2011 at 01:48, Reindl Harald h.rei...@thelounge.net wrote:
i would use a samll class holding the db-connection with insert/update-methods
pass the whole record-array, lokk what field types are used in the table
and use intval(), doubleval() or mysql_real_escape-String
By the
Am 20.09.2011 01:23, schrieb Dotan Cohen:
On Tue, Sep 20, 2011 at 01:48, Reindl Harald h.rei...@thelounge.net wrote:
i would use a samll class holding the db-connection with
insert/update-methods
pass the whole record-array, lokk what field types are used in the table
and use intval(),
Personally I don't use any quotes for the numeric types, and single quotes for
everything else. Ie:
UPDATE mytable SET int_field = 5 WHERE id = 3;
SELECT id FROM mytable WHERE int_field = 5;
UPDATE mytable SET varchar_field = 'Test' WHERE id = 3;
SELECT id FROM mytable WHERE varchar_field
On Sun, Sep 18, 2011 at 17:44, Brandon Phelps bphe...@gls.com wrote:
Personally I don't use any quotes for the numeric types, and single quotes
for everything else. Ie:
Thanks, Brandon. I understand then that quote type is a matter of
taste. I always use double quotes in PHP and I've only
On Sun, Sep 18, 2011 at 12:28 PM, Dotan Cohen dotanco...@gmail.com wrote:
On Sun, Sep 18, 2011 at 17:44, Brandon Phelps bphe...@gls.com wrote:
Personally I don't use any quotes for the numeric types, and single
quotes
for everything else. Ie:
Thanks, Brandon. I understand
in the table,
I'll include the $id in single quotes in the PHP statement, so even if the
value of $id is null, alpha, or invalid (not numeric) it does not generate a
mysql syntax error
what ugly style - if it is not numeric and you throw it to the database
you are one of the many with a sql
Lex Thoonen,all
UPDATE `jos_content` SET `introtext` = replace(`introtext`,h2
style=\margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet
MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;
font-size: 30px; color: #b4b4be;\,h2)
just gives me 0 results...
How about
Hi,
I'm trying to replace this:
h2 style=margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet
MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;
font-size: 30px; color: #b4b4be;
but
UPDATE `jos_content` SET `introtext` = replace(`introtext`,h2
style=\margin: 0px 0px
|
++-++--+---+--+-+--+-+-+
| 1 | SIMPLE | bite_event_log | ALL | id_file_set | NULL | NULL
| NULL | 1213328 | Using where |
++-++--+---+--+-+--+-+-+
Here the quotes are forcing MySQL to see strings where it should see
Hi,
I guess the id_file_set is an INT?
The problem si most likely due to the fact you are comparing integer to
string, which forces MySQL to use type conversion. For more information
check http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html
When type conversion occurs MySQL will not
I'm really confused. First, I don't understand why quoting my IN()
values here caused them to run significantly slower than the non-quoted
versions... on just this simple contrived example it can be as much as
2.2 seconds vs. 0 seconds to return on a table that has 2.5M rows.
The problem I'm
How do I get mysqldump to turn off quotes e.g from
INSERT INTO table
to
INSERT INTO table
Thanks
Martin Gainty
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender
In the last episode (Jul 02), Martin Gainty said:
How do I get mysqldump to turn off quotes e.g from
INSERT INTO table
to
INSERT INTO table
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL
tried doing the mysqldump with --compatible=ansi which changes the
backticks to double quotes, but get the same error,
ERROR 1049 at line 25: Unknown database 'db1'.
I can't edit dumpfile as it is 8Gb (ok, I can split it and stuff like
that ... but come on!!)
What am I missing here? Has anyone
the database name.
Looking at dumpfile, I see,
use `db1`
I tried doing the mysqldump with --compatible=ansi which changes the
backticks to double quotes, but get the same error,
ERROR 1049 at line 25: Unknown database 'db1'.
I can't edit dumpfile as it is 8Gb (ok, I can split it and stuff like
Hi,
yes, the create database succeeds. It's in a show databases. The error
message is complaining about `db1` (i.e. quotes followed by backtick).
I'm actually using rsync to copy the file (faster than ftp for some
reason). But it also failed when I originally ftp'd it.
I've also tried
thanks for your response.
I'm already working on the php part but just wondered how bad is to
have backslash in front of quotes.
It's bad in the sense that you will have to predict every single event
(character) from the input and act accordingly. The API writers had
predicted them all
hi to all.
battling this problem on several forums and mailing lists, I got confused:
when store string that contains quotations (ie afan's php shop) in mysql
does it have to be stored with backslashes (afan\'s \php\ shop) or just
the way it is? my login's telling me the way it is. am I wrong?
to
unescape the slashes generally. Unfortunately I can't remember in PHP if
that's because of magic quotes or just the way the db has it stored. My gut
instinct is the former.
thanks for any help.
-afan
--
Chris White
PHP Programmer/DBaboon
Interfuel
--
MySQL General Mailing List
For list
remember in PHP
if
that's because of magic quotes or just the way the db has it stored.
My
gut
instinct is the former.
No no no no. If you have to unescape your data before you display it,
then you escaped it too many times.
If you have the following query:
INSERT INTO myTable VALUES ('I\'m
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
[ stuff here ]
kgt
I'm confused.. did you read my email? Most of what you said doesn't seem to
correlate with what I said. Can you quote the specific lines that you're
disagreeing with?
--
Chris White
PHP Programmer/DBacillus
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006 11:43 AM
To: mysql@lists.mysql.com
Subject: Re: how to store quotes in mysql?
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
[ stuff here ]
kgt
I'm confused
[EMAIL PROTECTED] wrote:
hi to all.
battling this problem on several forums and mailing lists, I got confused:
when store string that contains quotations (ie afan's php shop) in mysql
does it have to be stored with backslashes (afan\'s \php\ shop) or just
the way it is? my login's telling me
thanks for your response.
I'm already working on the php part but just wondered how bad is to
have backslash in front of quotes.
thanks.
-afan
[EMAIL PROTECTED] wrote:
hi to all.
battling this problem on several forums and mailing lists, I got
confused:
when store string that contains
OK, I'm bad - I have curly quotes in my db that I failed to eliminate
prior to the insert. Now that they're in there, is there a way to
replace them with straight quotes? Everything I try fails to find them.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Monday, December 05, 2005 2:13 PM
To: mysql@lists.mysql.com
Subject: Killing my curly quotes
OK, I'm bad - I have curly quotes in my db that I failed to eliminate prior
to the insert. Now that they're in there, is there a way to replace them
)
Now suppose that in my table, plastique ou carton are between
double quotes. I have a search engine in which users can enter an
exact phrase search. So in my code I insert this phrase they want to
find between double quotes in my fulltext search, just as in example
2. But what if they want to find
Hello.
and I want to search for this exact phrase, including double quotes,
You can't do this, because fulltext search operates with words,
and double quotes not a word. Also an order of the sequence of
words doesn't have a sence for a fulltext search.
CheHax [EMAIL PROTECTED
Hello.
At first: from your phrase with default values for the FULLTEXT
parameters there is the only one meaningful word - football.
Because 'I', 'on', 'TV' has less than 3 characters. 'like' is
in the stopword list. Quotes '' - are skipped from the search.
What query do you use to search
Hi list,
I'm trying to figure out how to use the exact phrase search in
fulltext boolean mode when the phease to search includes double
quotes.
For instance, what if I want to search this exact phrase :
I like football on TV
I think I've tried all the solution I'm aware of without any results
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull [EMAIL PROTECTED] wrote:
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the
When I look at the dump file, I see that one of the invalid characters is
represented as /226 I'll have to look to see if it is consistent, and just
replace it.
Thanks.
Quoting [EMAIL PROTECTED]:
are you sure that the single/double quotes in your original data were
actually the standard
replace it.
Thanks.
Quoting [EMAIL PROTECTED]:
are you sure that the single/double quotes in your original data were
actually the standard ascii characters (decimal 39 (') and 34 ()) --
not smart quotes? you shouldn't have any trouble with the standard
quote characters
On Wednesday 15 December 2004 15:38, Dave Juntgen might have typed:
Hi!
Could someone please explain to me why the second query below is faster
then the first query? The only difference between the two is that
ext_doc_id's value is quoted. Index and column information follow and the
table
Hi!
Could someone please explain to me why the second query below is faster then
the first query? The only difference between the two is that ext_doc_id's
value is quoted. Index and column information follow and the table being
queried contains approximately 3.5 million rows.
Thanks!
/doc/mysql/en/RESET.html
The quoting rule is: If it's a NUMBER, don't quote it. Strings get quotes,
so do dates. Database elements (tables, columns, etc. ) whose names are a
reserved word or contain invalid characters (like spaces) or are otherwise
invalid would need to be surrounded by backticks
PROTECTED]
Sent: Wednesday, December 15, 2004 11:10 AM
To: Dave Juntgen
Cc: [EMAIL PROTECTED]
Subject: Re: To use Quotes or not to, that's the question.
In the last episode (Dec 15), Dave Juntgen said:
Could someone please explain to me why the second query below is
faster then the first query
In the last episode (Dec 15), Dave Juntgen said:
ext_doc_id is a CHAR type, which means that you may have two rows,
0412625, and 412625, both of which match the expression WHERE
ext_doc_id=412625. MySQL can't use an index because it has to
convert each field to a number before doing the
In the last episode (Dec 15), Dave Juntgen said:
Could someone please explain to me why the second query below is
faster then the first query? The only difference between the two is
that ext_doc_id's value is quoted. Index and column information
follow and the table being queried contains
From: David Blomstrom [EMAIL PROTECTED]
--- Chris W [EMAIL PROTECTED] wrote:
If you plan on using this process again, you may
want to track down the
source of the problem, but if you aren't going to
The source of the problem is the fact that it is common in a CSV file to
represent a quote
This isn't directly related to MySQL, but I thought
someone might have an answer - or maybe there's a way
MySQL can deal with it.
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I
David Blomstrom wrote:
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I saved the file as a csv file. In other words,
they now look like this:
a href=www.geobop.org/Geobop/a
Do you
--- Chris W [EMAIL PROTECTED] wrote:
If you plan on using this process again, you may
want to track down the
source of the problem, but if you aren't going to
be exporting this way
again and you just want to fix it, I would just open
the csv file in a
text editor and do a search and
Just by curiosity is there any difference between this 2 queries
select * from users where users_id=10
and
select * from users where users_id='10'
assuming that the users_id column is of type integer primary key (if it
would be varchat I know there is a big difference)
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe or
as MySQL would see it the single quote. I was hoping to be able to use
double quotes to overcome the need to constantly have to escape the
apostrophe
[snip]
Are my prayers answered? I have been a bit concerned that I might not
be able to completely fulfill my clients needs because of them being
restricted to the use of single quotes.
[/snip]
Mat,
What is your programming language for the site? If it is PHP you have a
wealth of options
Matthew Stuart said:
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe
or as MySQL would see it the single quote. I was hoping to be able
to use double quotes to overcome the need to constantly have
You could always write your own function to do the escaping for you. This following
link is an example written in VB that you could adapt to whatever language you are
using.
http://www.vbmysql.com/samplecode/stripquote.html
Here is another way of doing it if you can link to the libmySQL.dll
On Mon, 08 Dec 2003 19:07:43 +, zzapper [EMAIL PROTECTED] wrote:
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
B)
Now I can filter any quotes from form.searchtext easy enough, but how
do I filter
Hi Ya.
I seem to have solved my problem if I clean out any punctuation from
my search string (see below (ColdFusion script))
cfset form.searchtext=replace(form.searchtext,'[[:punct:]]','','all')
When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes
The LIKE appears to ignore
for for a name that
contains a quote eg a development named King's Reach it is not found.
A)
Now it simply won't match King's Reach whether I include the quote or
not. WHY?? (Have the quotes been converted ie to URL Encoding))
Consider what your query looks like when form.searchtext contains a
single quote
On Tue, 09 Dec 2003 13:24:03 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You don't want to filter the quotes from the input string, because they
exist in the data. (Well, you could filter from both sides, but that's
inefficient.) What you need to do is escape the quotes with backslashes
won't match King's Reach whether I include the quote or
not. WHY?? (Have the quotes been converted ie to URL Encoding))
B)
Now I can filter any quotes from form.searchtext easy enough, but how
do I filter them the Left Hand Side eg from txtDevName?)
I look forward to seeing how you solve
Matthew,
I really don't understand the question. Apostrophes must be properly
escaped when text is inserted into the MySQL db, but any perl script will
easily do this for you. You may convert to HTML at the same time.
If the database gives nothing but a path to a *.txt source then your HTML
code
[snip]
The site is a news based site and has the use of the single quote or
apostrophe (') through most of it's articles. I think that each
article
at present is an external .txt file that is pulled in to Oracle. If I
carried on this method of having an external .txt file would that over
come
I am going to take over an existing website and in its present format
it is a site powered by an Oracle DB. I will be migrating to MySQL.
The site is a news based site and has the use of the single quote or
apostrophe (') through most of it's articles. I think that each article
at present is
/2003 11:30 Subject: single quotes in database
AM
I am using PHP/MySQL and am having a problem. We have some names and
addresses in the database that have single quotes in them. For
instance. There is a town around here called Lee's Summit. Also names
like O'connel. When I pull from the database it skips these because of
the quotes. I
[EMAIL PROTECTED],
mysql [EMAIL PROTECTED]
cc:
11/07/2003 11:30 Subject: single quotes in database
At 15:58 +1000 20-10-2003, Kim Kohen wrote:
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace
Kim Kohen [EMAIL PROTECTED] wrote:
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use to query the db but I have
I'm writing some routines which generate SQL queries, and I'm trying to
keep things generic. As such, I have a routine to SQL Escape some text,
such that it can be used in a query without breaking anything. This
routine predominantly consisted of preceeding all single quotes
Carl,
Friday, May 17, 2002, 7:59:49 AM, you wrote:
CJM Description:
CJM According to the documentation at
CJM http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes
CJM around a phrase within the AGAINST clause of a full-text boolean mode
CJM search should match only
Description:
According to the documentation at
http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes
around a phrase within the AGAINST clause of a full-text boolean mode
search should match only rows which contain this phrase exactly as
typed. Instead, it appears
The mySQL manual says that embedded double quotes within a single quoted
expression (as in 'OHara') need no special treatment. However, when I try
to update a data base field using such an expression, as in:
UPDATE table set col1='OHara'
the result I get is that everything
Please ignore earlier message -- mySQL stores embedded quotes just fine.
Wyckham Seelig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Hi,
I have a while loop pulling information into an editing form. It labels
variables dynamically as so:
name=schooling?php echo $counter?
Where $counter is augmented each time through the loop. In order to then
insert these, I need to do an insert of $schooling$counter. Below is the
statement
this with a little sql:
select ucase(?test?)
I try different things to solve : concat, '?var?', ... but i don't find
a way to bypass.
Have anyone a better solution?
Just use quotes when inserting values.
I could (when I find time), do it automatically if column is
char/varchar/text/blob
.
We can test this with a little sql:
select ucase(?test?)
I try different things to solve : concat, '?var?', ... but i don't find
a way to bypass.
Have anyone a better solution?
Just use quotes when inserting values.
I could (when I find time), do it automatically if column is
char/varchar
I try to use the ?var?'s to create a menu for inserting new rows in a table.
for example:
insert into personnel(first_name, last_name) values(?first_name?,
?last_name?)
if i type jean in first_name and maupertuis in last_name the result is
unknow column
'jean' in 'field list' because it's
quotes
when writing the name of your company, (i.e. Limited Liability Company
Widgetron). Anyhow, one of the scripts that I am using has ? echo
$companyname;?
It works great when the person isn't using quotes in the company name, but
when they are the quoted part disappears. If everyone was using
- Original Message -
From: Gregory Jon Welling/Parts Trading Inc. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
This is more of a php problem than mysql, but since I am using them in
combo...
I have a database for people from
Sorry bout the blank one.
try this
?=htmlspecialchars($companyname)?
Jim Lucas
- Original Message -
From: Gregory Jon Welling/Parts Trading Inc. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
This is more of a php problem than mysql
Does anyone know how to delete double quotes from my entries ''.
I thing you can use regular expressions.
Dexter,
The following resources may be of interest to you:
The MySQL Manual, particularly:
7.1 Literals: How to Write Strings and Numbers,
7.4 Functions for Use in Select and Where
Hi Mysqlers,
Does anyone know how to delete double quotes from my entries ''.
I thing you can use regular expressions.
Dexter
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Greetings MySQLers!
This messages is about MySQL. (had to put that in for the spam filter)
I have a record in my database:
productID Title
4 This title has a ' in it.
In the database, this is actually stored as:
productID Title
4 This title has a \' in it.
I have a query:
1 - 100 of 104 matches
Mail list logo