Hello, I'm new to mysql (and databases, fo that matter) and have problems finding a solution. The situation is as follows: I have one table with filtered information about users, the columns are, say, id, field and value. As you can see, any id can have more rows assiciated with him, each containing one crucial piece of information. Now I want to search the values for something and return all rows with the same id -- in effect this means that I cannot use "select * from t where value like ... ", which does, of course, return all rows that match the expression rather than all rows with the same id that happened to also contain a value with the expression.
If I'm not clear enough, here's an example: id field value --|-----|------- a x string1 a y string2 b x string3 a z string4 "select * from t where value like string2" returns the second row, but I want to return all rows with the same id as in row number two. I've tried this subquery, to no avail: select * from t where id = (select id from t where value like '%string2%' limit 1) Thanks, andrej -- echo ${girl_name} > /etc/dumpdates http://sonet.homelinux.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]