select from part of column query

Expand Post »

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"?

Similar Threads

Query logic in MS SQL
retrieving a particular value with a sql query in PHP
Error accessing database in ColdFusion
Get All Rows In Column In A Where Statment in MS SQL
How to auto increment? in ASP.NET

peanutong

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Aug 2008

Permalink

Aug 25th, 2008

Re: select from part of column query

MS SQL Syntax (Toggle Plain Text)
SELECT * FROM tb_TableName WHERE AColumn LIKE 'user1%'
select * from tb_TableName where AColumn like 'user1%'

Last edited by huangzhi; Aug 25th, 2008 at 5:12 am.

huangzhi

Reputation Points: 10

Solved Threads: 13

Light Poster

Offline

48 posts
since Feb 2008

Permalink

Aug 30th, 2008

Re: select from part of column query

sql Syntax (Toggle Plain Text)
SELECT*FROM (Tablename) WHERE (Colom) ," "
Select*from (Tablename) Where (Colom) ," "

Last edited by peter_budo; Aug 30th, 2008 at 5:43 am. Reason: Keep It Organized - please use [code] tags

prasannapower

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: MS Access to MS SQL Server

Next Thread in MS SQL Forum Timeline: SQL help

DaniWeb Message

Cancel Changes

User Name
Password