r937 wrote: > SELECT ... > FROM users > WHERE name LIKE CONCAT('%',username,'%') > > ;o) > > > rudy > http://simply-sql.com which masterfully leads to the answer to Q3: mysql> select name, username, email from users where name like CONCAT('%',username,' ',username,'%'); Thanks Rudy - Bob