Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...

Extracting a substring from a given string without the length parameter. SELECT SUBSTR('MySQL Tutorials', 3) AS SubString; -- O/P SQL Tutorials # Extracting a substring from a given string with the ...

string _thestring = "text to display: text we do not want to display"; // define the full string string _text_to_display = _thestring.Substring(0, _thestring.IndexOf(":") -1); // display text from the ...