Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL QUERY Expand / Collapse
Author
Message
Posted Thursday, September 18, 2008 11:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 18, 2008 11:45 PM
Points: 1, Visits: 0
sql query to find a particular word in a field of table

eg: in a field, gunapandian is a name, if i give "gun" it should give the row id.

those who know please tell me...
Post #572271
Posted Friday, September 19, 2008 12:11 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 8:57 AM
Points: 3,138, Visits: 1,060
Select * from table_name where name like'gun%'




Post #572281
Posted Friday, September 19, 2008 8:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 23, 2014 5:59 AM
Points: 329, Visits: 470
gunapandian.mca07 (9/18/2008)
sql query to find a particular word in a field of table

eg: in a field, gunapandian is a name, if i give "gun" it should give the row id.

those who know please tell me...

What if the column has the value 'surgunam'?




Madhivanan

Failing to plan is Planning to fail
Post #572545
Posted Thursday, March 14, 2013 12:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:17 AM
Points: 4, Visits: 70
select * from table_name where name like '%gun%';
Post #1430777
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse