what is the best way to weigh results in a select query?
example:
table test (a varchar(100))
--------------------------
(record) value
(1) this is a test line
(2) this is another test line containing the word line twice
If i want to perform a 'select from test where a like "%line%" and have the order appear with the records containing 'line' the most first - what is the best way? Are there mysql commands - or should I create a PHP array and manipulate it's contents?
Linear Mode
