First Search Title then Search Tag Query Order By Example

DB::select(
    "SELECT *
       FROM  table_name
       WHERE column_name LIKE '%".$search_word."%'
       ORDER BY
        CASE
        WHEN column_name LIKE '".$search_word."' THEN 1
        WHEN column_name LIKE '".$search_word."%' THEN 2
        WHEN column_name LIKE '%".$search_word."%' THEN 3
        WHEN column_name LIKE '%".$search_word."' THEN 4
        ELSE 5
    END")