如何在mysql中获取左子字符串

在下面尝试获取parent_path

select reverse(substring(reverse('/application/themes/openbank/images/prettyPhoto/light_square/default_thumbnail.gif'),instr(reverse('/application/themes/openbank/images/prettyPhoto/light_square/default_thumbnail.gif'),'/')))

select substr( path, 1, instr(path, substring_index( path, '/', -1)) - 1 ) as "PARENT_PATH", substring_index(path, '/', -1 ) as "FILE_NAME" from table1;

另一种方式是将LEFT、SUBSTRING_INDEX和CHAR_LENGTH组合: 我的解决方案采用字符串的左侧部分,长度=长度(绝对路径)-长度(文件部分)。

SET @content = '/application/themes/openbank/images/prettyPhoto/light_square/default_thumbnail.gif';
SELECT 
    LEFT(
       @content, 
       CHAR_LENGTH(@content) - CHAR_LENGTH(SUBSTRING_INDEX(@content, '/', -1))
    );

请参阅以下三个开头的答案 this fiddle .

我相信还有其他一些方法可以达到预期的效果。