[thelist] Quick SQL help...

Ken Moore psm2713 at hotmail.com
Wed Aug 30 19:32:06 CDT 2006

Hi all,

Rob Smith wrote,

>Is there an easy way to find a list of SKU's that remotely match another
>one in the list? The sample result might look like:

That depends on your definition of "easy." It also depends on whether or not 
you need to include the whole SKU. If so, it is easy using the like 

WHERE PossibleMatch LIKE %ThisSKU%

If you need only match a fraction of the SKU, then it is not easy. I will 
use PHP seudo code.. First you need to decide how many charters will 
constitute a mach. Then loop thru that many minus the total length.

$LengthToMatch = 5
for ($i = 0, $i = sizeof(ThisSKU) - $LengthToMatch, $I++) {
	$ThisTry = assign the substring from $i for $LengthToMatch chars
if ($ThisTry == $ItemToMatch) {
	Do something;

1.	The above is for one item to match. If there is a list, you will need a 
for loop to get all of them.
2.	It has been a while since I have used PHP and all of my books oar on 
loan. Sorry!


>SKU             Match
>ABC123      EPSABC123
>DFE332       EPSDFE332
>Rob Smith
>rob.smith at lexjet.com
>(941)330-1210 Int'l
>(941)330-1220 Fax
>1680 Fruitville Road, 3rd Floor
>Sarasota, FL 34236
>* * Please support the community that supports you.  * *
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

Search from any web page with powerful protection. Get the FREE Windows Live 
Toolbar Today!   http://get.live.com/toolbar/overview

More information about the thelist mailing list