Post reply

SQL QUERY

  • September 18, 2008 at 11:48 pm

    #382731

    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...

  • September 19, 2008 at 12:11 am

    #874023

    Select * from table_name where name like'gun%'

  • September 19, 2008 at 8:02 am

    #874233

    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

  • March 14, 2013 at 12:27 am

    #1596837

    select * from table_name where name like '%gun%';

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply