Posted by Tyno Gendo on 09/28/07 10:17

tower.grv@gmail.com wrote:
> Hello.
>
> I have gotten the problem.
> I have two tables with products in mysql database. I need to code php
> script that will connect products by name.
> But names can be some different (like another words order, or
> additional spaces, commas, dephises ect.)
>
> Can someone recommend me php class of show some example how to do
> this?
>
> Thanks.
>

Could be tricky depending on how different the names are, but you can
use MySQL's LIKE function and perhaps it's REPLACE and REGEX options,
you might be best asking in a SQL newsgroup.

Try selecting into another table, then export the two tables into a
spreadsheet and manually compare afterwards for things that might be
missed or wrong.

[Back to original message]