mysql 以 哪个字段结尾

1.

select  * from girl ;

# +--+----------------+------+-----+
# |id|name            |boy_id|name0|
# +--+----------------+------+-----+
# |1 |慕容吹雪-慕容博-慕容吹雪   |1     |慕容吹雪 |
# |2 |慕容吹雪-慕容吹雪-慕容吹雪2 |1     |慕容吹雪2|
# |3 |慕容吹雪3-慕容吹雪-慕容吹雪3|3     |慕容吹雪3|
# |4 |慕容吹雪4           |3     |NULL |
# |5 |慕容吹雪5           |3     |NULL |
# |6 |慕容吹雪6           |NULL  |NULL |
# |7 |D               |NULL  |NULL |
# |88|C               |8     |NULL |
# +--+----------------+------+-----+

# 选出 name 以   慕容吹雪  结尾的 数据
select  * from girl where name like '%-慕容吹雪' ;

# +--+-------------+------+-----+
# |id|name         |boy_id|name0|
# +--+-------------+------+-----+
# |1 |慕容吹雪-慕容博-慕容吹雪|1     |慕容吹雪 |
# +--+-------------+------+-----+


# 进阶 选出 name 以   name0  结尾的 数据
select  * from girl where name like concat('%-',name0) ;
# +--+----------------+------+-----+
# |id|name            |boy_id|name0|
# +--+----------------+------+-----+
# |1 |慕容吹雪-慕容博-慕容吹雪   |1     |慕容吹雪 |
# |2 |慕容吹雪-慕容吹雪-慕容吹雪2 |1     |慕容吹雪2|
# |3 |慕容吹雪3-慕容吹雪-慕容吹雪3|3     |慕容吹雪3|
# +--+----------------+------+-----+