select * from tablename where substring_index(field1,'_',-1)=‘abc'
#表中field1的值结构为123_abc
相关文章
- 12-09[MySQL]快速解决"is marked as crashed and should be repaired"故障
- 12-09MySQL 问题分析：ERROR 1071 (42000) : Specified key was too long; max key length is 767 bytes
- 12-09spring boot 中属性注入，application.properties 自定义前缀以及使用properties 封装mysql
- 12-09.net core系列之《.net core中使用MySql以及Dapper》
- 12-09.NET Core开发日志——Dapper与MySQL
- 12-09mysql数据目录移动
- 12-09/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh: line 19: mysql: command not found
- 12-09Dapper操作Sql Server和MySql数据库
- 12-09sql处理字符串: replace替换, substring_index拆分和处理json
- 12-09mysql数据库连接 application.properties