mysql两个字符串之间,mysql的两个字符串之间的区别

I want to find the difference between two strings in MySQL. Say, if two strings like nishant and nisha are input, then 'nt' should be output.

解决方案set @string2 :="nishant";

Query OK, 0 rows affected (0.00 sec)

set @string1 := "nisha";

Query OK, 0 rows affected (0.00 sec)

select @string1, @string2;

+----------+----------+

| @string1 | @string2 |

+----------+----------+

| nisha | nishant |

+----------+----------+

1 row in set (0.00 sec)

select if(length(@string1)>length(@string2), replace(@string1, @string2,""), replace(@string2, @string1, "")) as "The Difference";

+----------------+

| The Difference |

+----------------+

| nt |

+----------------+

1 row in set (0.00 sec)