I just learned a lot stuff at
http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by
number-to-text, text-to-number, names, specific values, etc.
However, the document didn't mention on how to sort by relevance.
For instance, someone search for "Ang":
COLUMN NAME: name
COLUMN TYPE: varchar (255)
DATA:
John Ang
La Chi Zoygote
Anglosaxon
Marco Polo
Ang Fernandez
John Pang Cuyi
Query result should be:
Ang Fernandez
John Ang
Anglosaxon
John Pang Cuyi
Is it possible to sort a column this way?
^_^ Thanks in advance. ^_^
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
