mysql的sql扩展名文件是_mysql – 如何通过sql查询获取文件的文件扩展名？

你可以使用

SUBSTRING_INDEX.喜欢这个：

select linkurl as DOWNLOADURL,lastrevlevel as VERSION,

code as DESCRIPTION,created as RELEASEDATE,

SUBSTRING_INDEX(name,'.',-1) as TYPE

from datas where id in

(select child_id from datas _datas

where parent_id=( select max(id) from datas

where code = 'AN4307SW'))

编辑

如果您看到有关此功能的文档,我认为这将很好地适用于您的要求.

Returns the substring from string str before count occurrences of the

delimiter delim. If count is positive, everything to the left of the

final delimiter (counting from the left) is returned. If count is

negative, everything to the right of the final delimiter (counting

from the right) is returned. SUBSTRING_INDEX() performs a

case-sensitive match when searching for delim.

这也将处理这样的情况：

select SUBSTRING_INDEX('Test.Document.doc','.',-1);

EDIT2

如果你正在使用oracle.请在下次正确的问题上标记问题. oracle中没有SUBSTRING_INDEX.但我能看到你可以很容易地做到这一点：

SELECT SUBSTR('Test.Document.doc', INSTR('Test.Document.doc', '.',-1))

FROM dual;

像这样的完整查询：

select linkurl as DOWNLOADURL,lastrevlevel as VERSION,

code as DESCRIPTION,created as RELEASEDATE,

SUBSTR(name, INSTR(name, '.',-1)) as TYPE

from datas where id in

(select child_id from datas _datas

where parent_id=( select max(id) from datas

where code = 'AN4307SW'))