|
|
Posted by C. (http://symcbean.blogspot.com/) on 09/28/07 11:19
On 28 Sep, 11:17, Tyno Gendo <nob...@example.com> wrote:
> tower....@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.
Certainly it depends what the OP means by 'connect', if it's 'join'
then it should be at the database level - but that's a workaround of
the real problem where the same physical entity is described by
different labels in different contexts.
C.
Navigation:
[Reply to this message]
|