Search code examples
mysqlcomparestring-comparisongroup-concat

Compare two strings using MYSQL

I have two strings in comma separated. String1='ABC,DEF,PQR,MNO,XYZ' String2='PQR,FGH' String3='GHI,JKL,TUV' Now I want that, compare string1 and string2, it will return true because String2 has value 'PQR' that matches with String1. But If I compare String1 and String3, it will return false because none of the string from string 3 match with String1. Note : Both Strings I got using Group_concat function.

Solution

  • I got the solution using FIND_IN_SET() function. Thank you for your efforts.