Re: [PHP] Getting Similar rows from db

On Fri, February 23, 2007 12:35 pm, Wikus Möller wrote: > I need a script that selects all similar rows from a database. Like > only the id would differ, but other fields would be the same as other > rows's fields. > > I don't know if there is such a mysql statement like SELECT SIMILAR > ... > > Pl

RE: [PHP] Getting Similar rows from db

I don't think there's a way to do it with SQL in MySQL. Jay's talking about a substring search within a field and what you really want is to know if two whole rows (multiple columns) within a database are similar or not. You could pull in all the data and use PHP to figure out what's similar (b

RE: [PHP] Getting Similar rows from db

> -Original Message- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > Sent: Friday, February 23, 2007 1:51 PM > To: Wikus Möller; php-general@lists.php.net > Subject: RE: [PHP] Getting Similar rows from db > > [snip] > I need a script that selects all similar ro

RE: [PHP] Getting Similar rows from db

[snip] I need a script that selects all similar rows from a database. Like only the id would differ, but other fields would be the same as other rows's fields. I don't know if there is such a mysql statement like SELECT SIMILAR ... Please assist me with using the right mysql statement or using ph