Searching through Tables

Results 1 to 2 of 2

Thread: Searching through Tables

  1. #1
    Join Date
    Dec 1969

    Default Searching through Tables

    I want to search a database for a certain string containing value entered by users. I know how to search with SQL by comparing the string to the data in all seperate fields in a table, but that way I get gigantic SQL statements. Isn&#039;t it possible to search with only the table name and not all fields seperately?<BR><BR>Thanks.

  2. #2
    Sivaram Jagadeesan Guest

    Default RE: Searching through Tables

    One way is concatenating all the fields and have a single big field and apply LIKE. <BR>If it is SQL 7.0 you can use Full text catalog index search. To do this you have to build the full text catalog with all the fields you want and you have to populate the catalog [All can be done in few clicks]. <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts