This discussion is archived
5 Replies Latest reply: Dec 6, 2012 1:42 AM by Rahul_India RSS

Selecting records based on value of field

Rahul_India Journeyer
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points