Is there a way to do something like a 'select * where forename_1,forename_2,surname like '%String%' ??
You could try the following, but it won't get a medal for performance...SELECT * FROM xpto WHERE forename_1 LIKE '%String%' OR forename_2 LIKE '%String%' OR surname LIKE '%String%'
Helder M. Vieira
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
