MySQL Forums
Forum List  »  Newbie

Finding the difference between two strings
Posted by: James Allwood
Date: April 13, 2009 04:15AM

Hello again. Ok, I have two varchar fields in my database, and basically I want to use sql to compare the two fields and output the difference.

For example

Field 1 - Tartan Bean Bag Cover Red
Field 2 - Tartan Bean Bag Cover small 24 Red

I would like to compare and get the output -

Output - small 24

Anyone with any ideas? Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Finding the difference between two strings
April 13, 2009 04:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.