Member Avatar for 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"?

  • 3 Contributors
  • 2 Replies
  • 112 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by prasannapower
Member Avatar for huangzhi 
select * from tb_TableName where AColumn like 'user1%'
Member Avatar for prasannapower 
Select*from (Tablename) Where (Colom) ," "
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.