[ Date Index ][
Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Neil Williams wrote: > What's the best way to compare two strings, each containing comma separated > values, to see if ANY of the values in the first string match any of the > values in the second string? > > Ideally, I'd like to do this within an existing SQL query I fear the SQL way would have had you put each element in a table, and so now all you would need is a subquery on the table linking whatever has the attributes to the attributes. > $string1 = "PHP, XML, GnuPG, standards, design"; > $string2 = "C++, Perl, PHP, networking, security"; > > So $string1 should give a match with $string2. > > There are many strings, no predetermined number of values or > case-requirements. The match must be as wide as possible - the intention is > to err towards over matching rather than missing just one possible match. > > Ideas? Can you not just turn one string into a series of "like '%$1%' [or] like '$2%'", it'll over match, but that is as requested..... I'm still trying to understand Peter's answer.... obviously I need more practice with replace, so SQL may yet surprise me. -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/DUhDGFXfHI9FVgYRArwZAJ9YpDQMXKOFjwni+NAc1eIieMgwNQCgnCR5 gvHMDlHgyruJNLkvg0ZM0S4= =I0ui -----END PGP SIGNATURE----- -- The Mailing List for the Devon & Cornwall LUG Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the message body to unsubscribe.