mysql> select userid,username from user where username like "filburt%"; +--------+----------+ | userid | username | +--------+----------+ | 1 | filburt1 | +--------+----------+ 1 row in set (0.00 sec)