select from part of column query

[peanutong]

how do i select data from a table by sorting the first word from a column?

for example:

"user1 hello"
"user2 one two three"
"user3 where are you"
"user1 im fine"

how can i select all the data starting with "user1"?

[huangzhi]

select * from tb_TableName where AColumn like 'user1%'

[prasannapower]

Select*from (Tablename) Where (Colom) ," "