jonhassall

        SELECT id, title
        FROM table
        ORDER BY
        CASE
        WHEN title regexp '^[a-zA-Z]+' THEN
        1
        WHEN title regexp '^[0-9]+' THEN
        2
        WHEN title regexp '^[^\w]+' THEN
        3

jonhassall

The birch canoe slid on the smooth planks
Glue the sheet to the dark blue background
It's easy to tell the depth of a well
These days a chicken leg is a rare dish
Rice is often served in round bowls
The juice of lemons makes fine punch
The box was thrown beside the parked truck
The hogs were fed chopped corn and garbage
Four hours of steady work faced us
A large size in stockings is hard to sell

jonhassall

<?php

namespace App\Traits;

/**
 * Fulltext search trait. Requires column to have a FULLTEXT index
 * Customizable weighted relevance per column
 * 
 * Add to model:
 *