MySQL sort by name

Question

Is it possible to sort the column in alphabetical order, but ignoring some words, for example, 'The'

eg.

A normal request will return

string 1
string 3
string 4
the string 2

I would like to return

string 1
the string 2
string 3
string 4

Is it possible?

EDIT Please note that I want to replace a few words, such as A, A, etc. Can this be done?

Answer 1

You can try

SELECT id, text FROM table ORDER BY TRIM(REPLACE(LOWER(text), 'the ', ''))

but note that for large datasets it will be very slow, since it has to recount a new row for each row.

IMO you are better off with a separate column with an index on it.

For multiple stopcodes, just keep nested calls REPLACE. :)

Answer 2

, ORDER-:

SELECT * FROM yourTable ORDER BY REPLACE(yourField, "the ", "")

Answer 3

"The"

SELECT  *
FROM    YourTable 
ORDER BY REPLACE(Val,'The ', '')

Answer 4

, 75 000 , . PHP script, , "A", "An" "The" . . .

, , . .