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"?
peanutong
0
Newbie Poster
Recommended Answers
Jump to Postselect * from tb_TableName where AColumn like 'user1%'
All 2 Replies
huangzhi
0
Light Poster
select * from tb_TableName where AColumn like 'user1%'
prasannapower
0
Newbie Poster
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.