{"title":"MySQL SUBSTRING","blog_title":"by shigemk2","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2024%2F11%2F06%2F195312\" title=\"MySQL SUBSTRING - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"author_name":"shigemk2","url":"https://www.shigemk2.com/entry/2024/11/06/195312","version":"1.0","blog_url":"https://www.shigemk2.com/","type":"rich","description":"SUBSTR\u306fSUBSTRING\u306e\u30b7\u30ce\u30cb\u30e0 \u8d77\u70b9\u306f0\u3058\u3083\u306a\u304f\u30661\u306a\u306e\u3067 mysql> SELECT SUBSTRING('Quadratically',5); -> 'ratically' mysql> SELECT SUBSTRING('foobarbar' FROM 4); -> 'barbar' mysql> SELECT SUBSTRING('Quadratically',5,6); -> 'ratica' mysql> SELECT SUBSTRING('Sakila', -3); -> 'ila' mysql> SELECT SUBSTRING('Sakila', -5, 3); \u2026","height":"190","provider_name":"Hatena Blog","published":"2024-11-06 19:53:12","width":"100%","categories":["MySQL"],"author_url":"https://blog.hatena.ne.jp/shigemk2/","provider_url":"https://hatena.blog"}