search json token in sql (useful if sql engine doesn't support json)

set @token = 'OrderBy';
SELECT *
FROM
  (
    SELECT replace( substring(settings, position(@token in settings) + length(@token) + 2,
                     locate(',', settings, position(@token in settings) + length(@token) + 2) - (position(@token in settings) + length(@token) + 2)),
      '"','') as field
    FROM widgets
  ) t
WHERE t.field != 'null';