BY feed_new.new_title;
[[...]]
The query is doing a scan of the 9816 records that have pub_id = @PUBID, but
even so this seems like a long time. Are the built-in string functions really
that slow?
The general rule is:
If you are not taking the value of a column directly but are applying
any function
Jerry,
On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz je...@gii.co.jp wrote:
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
I suspect that if you watch Handler_ stats, you'll find that the
EXPLAIN estimate is wrong for some reason and it's
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Wednesday, May 26, 2010 7:39 PM
To: je...@gii.co.jp; mysql@lists.mysql.com
Subject: RE: Slow query using string functions
Jerry,
Are you sure this is really your explain plan for this query? That's not at
all what I
/ FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of
Baron Schwartz
Sent: Thursday, May 27, 2010 9:09 AM
To: MySql
Subject: Re: Slow query using string functions
Jerry,
On Wed, May 26, 2010 at 5:13 PM
possible_keys: pub_id,pub_id_2
key: pub_id
key_len: 48
ref: const
rows: 9816
Extra: Using where
The query is doing a scan of the 9816 records that have pub_id = @PUBID, but
even so this seems like a long time. Are the built-in string functions really
using string functions
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
Table `feed_new` has a single VARCHAR(255) column, `new_title`, that is an
index.
Table `prod` has many fields: `prod_title` and `pub_id` are both indexes
(VARCHAR).
`feed_new
Hello MySQL Users
Is there a way to change the separator in the following example,
e.g. from , to '?
SELECT FORMAT(12332.123456, 4);
- '12,332.1235'
is this the easiest way?
SELECT REPLACE(FORMAT(12332.123456, 4), ,, ');
- '12'332.1235'
or can this be set somewhere?
Thank you!
Jay
--
Is there any function to strip non numeric characters from a string?
Such that FUNCTION('1-(519)-473-3853') would return '15194733853'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function to strip non numeric characters from a string
-List (E-mail)
Subject: RE: String Functions
Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function
-List (E-mail)
Subject: RE: String Functions
That I can do
REPLACE(REPLACE(REPLACE(REPLACE(str,'(',''),')',''),'-',''),' ','')
Looks kinda horrid to handle removing just four characters ( ) - and space
And if any other characters end up in str, then they are not handled, and my
formula is broken.
So
Is there a way to use a string concatenating function in connection with a
GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders
relation), to catch a structure like:
firm | stocholders
f_1 | s_1; s_2; s_3
f_2 | s_4; s_5
f_3 | s_6
instead of
firm |
If you're using MySQL 4.1, you have the GROUP_CONCAT(expr) function.
If not, then... i think someone has already done an UDF about this...
Search the archives..or see this:
http://www.cwts.nl/buter/misc/my-mysql.html
--
Diana Soares
On Wed, 2003-11-12 at 08:56, Ciprian Trofin wrote:
Is there
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT division,
G_CONCAT(, ,first_name) as nicks
David Garamond [EMAIL PROTECTED] wrote:
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT
Dear all,
I am wondering whether constant arguments are required in string functions, e.g.
Substring(str, pos, len).
Given MyTable:
...
MyString TEXT,(muti-byte characters)
MyPos UNSIGNED(10),
MyLength UNSIGNED(10).
While (1
problem.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Hu Qinan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 03 June, 2003 03:05
Subject: Constants required in String functions?
Dear all,
I am wondering whether constant arguments
Hu Qinan [EMAIL PROTECTED] wrote:
I am wondering whether constant arguments are required in string functions, e.g.
Substring(str, pos, len).
Given MyTable:
...
MyString TEXT,(muti-byte characters)
MyPos UNSIGNED(10
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure how to handle the
syntax with two sets of parentheses.
any insight?
tia,
j
At 12:39 -0400 9/20/02, Stanley, Jason wrote:
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure
how to handle the syntax with two sets of parentheses.
The
20 matches
Mail list logo
