please don't ask me to redesign my table and help me with sql query

Posted by saurav on Stack Overflow See other posts from Stack Overflow or by saurav
Published on 2010-03-18T12:27:11Z Indexed on 2010/03/18 12:31 UTC
Read the original article Hit count: 231

Filed under:

i have a table as given with name and 10 cities in which he lived during his lifetime.

name , c1 , c2 ... ,c10.

For a particular name i want to fetch other people who have lived in three or more cities lived by this person.

© Stack Overflow or respective owner

Related posts about mysql-query