How to use LIKE for mysql search with ORDER BY the count of most existence keyword in the table?

Asked Feb 23 '14 at 07:43

Active Feb 23 '14 at 07:43

Viewed 29 times

For example the table name is "test_table" The text-field name is test-text

    $search="internet";
    -----------------
    SELECT text-field  FROM test_table as t
    WHERE (t.text-fielde LIKE '%" . $search . "%')
    ORDER BY MAX(COUNT(XXX))  // xxx=result of LIKE  for $search

I hope you got my mean. I wana sortet result by number of searched word.

asked Feb 23 '14 at 07:43

user3307827

I could not use it. tnx anyway :) – user3307827 Feb 23 '14 at 08:01
Isnt this question confusing? I mean i have three fields and one of them contains internet, then the count is always going to be 1 is it not? Then how will max work in that case ? – Rat-a-tat-a-tat Ratatouille Feb 23 '14 at 09:41

How to use LIKE for mysql search with ORDER BY the count of most existence keyword in the table?

0 Answers0