5 Replies Latest reply: Dec 6, 2012 3:42 AM by Rahul_India RSS

    Selecting records based on value of field

    Rahul_India
      I have a table test with 10,000 records in it and 50 columns.
      I have to select those rows which contain values as "Sales Dum" in their field
      For table with small number of colums i did this
      SELECT * FROM tbl_website_dtl WHERE created_by like '%Sales%'
      or website_name like '%Sales%' or website_code like '%sales%';
      But should i do for table containing 50 columns.