howto search for content in mysql that starts with xxxx

[kumschick]

hallo,

i want to search in the database for all usernames that starts with administrator.

in the database i have:

administrator
administrator.test1
administrator.test2
administrator.test3
superuser
superuser.test1
superuser.test2
superuser.test3
userxxxxx
userxxxxx.test1
userxxxxx.test2
userxxxxx.test3
...

now i want to make a "select from $databaseX where username='administrator' ";

I want as result all administrators including the .test1 ; .test2 ; .test3

How do I search for that content

[laserlight]

you need a
WHERE username LIKE 'administrator%'