|
|
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.
Navigation:
[Reply to this message]
|