Won't a simple LIMIT 1 do what you want? Or am I missing something? Arthur
On Fri, Mar 13, 2009 at 3:24 PM, Nigel Peck <nigel.p...@miswebdesign.com>wrote: > Nigel Peck wrote: > >> SELECT >> `People`.`person_id`, >> `People`.`name` >> FROM >> `People` >> INNER JOIN >> `Person_postal_addresses` >> ON >> `Person_postal_addresses`.`person_id` = `People`.`person_id` >> WHERE >> `People`.`name` REGEXP 'example' >> OR >> `Person_postal_addresses`.`address` REGEXP 'example' >> ; >> >> >> >>
