[thelist] mysql pattern matching query

[Bob Meetin]

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