您需要使用MySQL的substring_index()函数来选择文本。
语法如下SELECT substring_index(yourColumnName,'/',-1) AS anyAliasName FROM yourTableName;
为了理解上述概念,让我们创建一个表。创建表的查询如下mysql> create table selectTextAfterLastSlashDemo
- > (
- > UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
- > UserPathDirectory varchar(200)
- > );
使用insert命令在表中插入一些记录。
查询如下mysql> insert into selectTextAfterLastSlashDemo(UserPathDirectory)
values('C:/MyFolder1/MyEntityFramework');
mysql> insert into selectTextAfterLastSlashDemo(UserPathDirectory)
values('D:/MySpringFrameworkDemo');
mysql> insert into selectTextAfterLastSlashDemo(UserPathDirectory)
values('E:/Java/MyRootFolder/Source/AllHibernateDemo');
mysql> insert into selectTextAfterLastSlashDemo(UserPathDirectory) values('C:/Program
Files/MySQL/Serv