今天写了个新sql记录一下
SELECT SUBSTRING_INDEX("www.zhukaifu.cn", ".", 1);
www
| id_attr | attrs |
| 1 | 123,456 |
| id | name |
| 123 | 测试 |
SELECT
*
FROM
`name`
LEFT JOIN `attr` ON name.id = SUBSTRING_INDEX(attr.attrs, ",", 1)
可以把SUBSTRING_INDEX用在JOIN里
今天写了个新sql记录一下
SELECT SUBSTRING_INDEX("www.zhukaifu.cn", ".", 1);
www
| id_attr | attrs |
| 1 | 123,456 |
| id | name |
| 123 | 测试 |
SELECT
*
FROM
`name`
LEFT JOIN `attr` ON name.id = SUBSTRING_INDEX(attr.attrs, ",", 1)
可以把SUBSTRING_INDEX用在JOIN里