Ok let's say I have a table for artists informations. Some artists have two names, let's use know ones, "Prince" and "The Artist"
I made a table artists that host different info for that artist, then made a table with artistnames where i have artistID and artistName. SELECT artistCity from artists,artistnames WHERE artists.artistID = artistnames.artistID AND artistName = "foo"; But, since there are maybe less than 1% of artists with many names, I tought maybe i could de-normalize my artists table to put artistName and artistAKA BUT, ever search would have SELECT artistCity FROM artists WHERE artistNAME = "foo" OR artistAKA = "foo" Which would disable the index searching because of the OR right? Please give some advises!!! Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
