mysql> describe boler; describe nickjoin; describe expl; +----------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | nick | varchar(10) | YES | | NULL | | | usermask | varchar(64) | YES | | NULL | | | full | varchar(100) | YES | | NULL | | | msgs | int(11) | YES | | NULL | | | joins | int(11) | YES | | NULL | | | parts | int(11) | YES | | NULL | | | quits | int(11) | YES | | NULL | | | nicks | int(11) | YES | | NULL | | | first | varchar(16) | YES | | NULL | | | last | timestamp(14) | YES | | NULL | | | quote | text | YES | | NULL | | | chars | int(15) | YES | | NULL | | +----------+---------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec) +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | nick | varchar(10) | YES | | NULL | | | alias | varchar(10) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) +---------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | author | varchar(100) | YES | | NULL | | | tid | timestamp(14) | YES | | NULL | | | ord | varchar(32) | YES | | NULL | | | innhold | text | YES | | NULL | | +---------+---------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> select nick,usermask,full from boler where full like "%wiz%"; +------------+-----------------------------+-----------------------------------------------+ | nick | usermask | full | +------------+-----------------------------+-----------------------------------------------+ | Wiz-grille | fd@*.bb.online.no | Wiz-grille!~fd@ti100710a080-1983.bb.online.no | | Wiz- | fd@*.bb.online.no | Wiz-!fd@ti100710a080-1023.bb.online.no | | Wiz- | fd@85.165.7.191 | Wiz-!~fd@85.165.7.191 | | Wiz | fd@*.bb.online.no | Wiz!~fd@ti100710a080-1983.bb.online.no | | Wiz- | jorgen@*.bb.online.no | Wiz-!~jorgen@ti100710a080-5359.bb.online.no | | Wiz-skole | adam@80.90.240.130 | Wiz-skole!~adam@80.90.240.130 | | Wiz-skole | adam@elvebakken.novanett.no | Wiz-skole!~adam@elvebakken.novanett.no | | Wiz-- | adam@elvebakken.novanett.no | Wiz--!~adam@elvebakken.novanett.no | | Wiz- | Wiz@*.bb.online.no | Wiz-!~wiz@ti100710a080-5359.bb.online.no | | Wiz-- | adam@80.90.240.130 | Wiz--!~adam@80.90.240.130 | | Wiz-mac | lol@*.bb.online.no | Wiz-mac!~lol@ti100710a080-5359.bb.online.no | | Wiz_ | Wiz@85.165.20.239 | wiz_!~wiz@85.165.20.239 | | Wiz- | jorgen@193.0.252.16 | Wiz-!~jorgen@193.0.252.16 | | Wiz_ | Wiz@193.0.252.16 | wiz_!~wiz@193.0.252.16 | | Wiz-linux | wiz@193.0.252.16 | Wiz-linux!~wiz@193.0.252.16 | | J0rgen | wiz@193.0.252.16 | J0rgen!~wiz@193.0.252.16 | | Wiz-- | wiz@193.0.252.16 | Wiz--!~wiz@193.0.252.16 | | wiz_ | wiz@*.bb.online.no | wiz_!~wiz@ti100710a080-5359.bb.online.no | | wiz | wiz@*.bb.online.no | wiz!wiz@ti100710a080-5359.bb.online.no | | Wiz-- | wiz@*.bb.online.no | Wiz--!~wiz@ti100710a080-5359.bb.online.no | | wiz__ | wiz@*.bb.online.no | wiz__!~wiz@ti100710a080-5359.bb.online.no | | Wiz- | adam@elvebakken.novanett.no | Wiz-!~adam@elvebakken.novanett.no | | Wiz- | wiz@85.165.20.239 | Wiz-!~wiz@85.165.20.239 | +------------+-----------------------------+-----------------------------------------------+ 23 rows in set (0.01 sec)