On 27/04/06, tedd [EMAIL PROTECTED] wrote:
On Wed, 2006-04-26 at 16:57, Robert Cummings wrote:
On Wed, 2006-04-26 at 16:51, tedd wrote:
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
Never tried it mysql, but I am led to believe that sorting based on
the result of the mysql SOUNDEX function may produce the results you
want. Other than that, as far as I am aware there is no way to do
this in MySQL without writing a stored procedure to do it.
-Stut
-Stut:
Damn, that
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
what I wanted).
As such, maybe if I post a MySQL question to the PHP group, then I'll
receive a MySQL answer -- so here goes:
I'm using the following
On Wed, 2006-04-26 at 16:51, tedd wrote:
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
what I wanted).
As such, maybe if I post a MySQL question to the PHP group, then I'll
receive a MySQL
On Wed, 2006-04-26 at 16:57, Robert Cummings wrote:
On Wed, 2006-04-26 at 16:51, tedd wrote:
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
what I wanted).
As such, maybe if I post a
tedd wrote:
SELECT id, title, url_image_small
FROM $dbtable
WHERE type=type_title
ORDER BY title
LIMIT $offset, $rowsPerPage
But, it sorts stuff like this:
Basel Square 1
Basel Square 10
Basel Square 11
Basel Square 2
Basel Square 3
Basel Square 4
Basel Square 5
Basel Square 6
Basel Square 7
You could try separating out the number an formatting it with SQL and doing an
ORDER BY on the post-processed number. It doesn't have to appear in the SELECT
columns portion to be able to use it in the ORDER BY section.
SELECT BookName, PageNum, Citation FROM BookQuotes ORDER BY
Crude, but effective.
ORDER BY length(title) DESC, title
You may also need to make it be:
ORDER BY substring(title, 1, 10), length(title) DESC, title
so you can get them alphabetical to start off with (the first 10
chars) then by the length to hack the longer ones with multiple
digits at the
Going to amend this by saying that whereever the number you need to sort by is
located, you should be able to extract it and do the padding trick even if it's
in the middle of a string.. as long as the format is regular enough.
-TG
= = = Original message = = =
You could try separating out
On Wed, 2006-04-26 at 16:57, Robert Cummings wrote:
On Wed, 2006-04-26 at 16:51, tedd wrote:
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
what I wanted).
As such, maybe if I post a MySQL
On Wed, 2006-04-26 at 21:15, tedd wrote:
On Wed, 2006-04-26 at 16:57, Robert Cummings wrote:
On Wed, 2006-04-26 at 16:51, tedd wrote:
Hi gang:
I posted the following question to the MySQL list, but the only
answer I received thus far was a php solution (it didn't work for
11 matches
Mail list logo
