A table of mine has a field called title, which I want to order by. However, many of the titles (not all though) start with S*, i.e. S*AAA or S*BBB. When ordering I want to ignore the S* part, but since all titles does not start with S* I cannot simply remove the first two characters with the substring() function.

I'm basically looking for an SQL equivalent to php's ltrim($title, "S*")

http://dev.mysql.com/doc/refman/5.0/...nction_replace

SELECT col FROM tbl ORDER BY replace(col, 'S*', '');

Ah, of course
Thanks!