Sorting by relevance?

[Erik Bukakis]

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. ^_^