Select row starting at certain character
I am using the below select statement to create a blurb on a homepage to pull readers into in article. The title for the article will always start with the phrase 'Learn more about'. In the blurb I would like the title to be 'Widgets' and in the main article I would like the title to be the full 'Learn more about Widgets'. I tried limiting the title text by using right(title, xx) but I have to change the number value each time. Anybody have a more dynamic solution? Thanks.
SELECT right(title, 16) title, image, left(body, 205) body
FROM content ORDER by id DESC limit 1