Results 1 to 3 of 3

Thread: Searching a table technique

  1. #1

    Searching a table technique

    Hello.

    I have an SQL database with a table that has about 20 columns and about 30 rows.

    I need to perform a search on the whole table based on the values from one row: I need to find what other rows have similar values with the row that I base my search on. The similarities can vary from 1 column to all 20 columns.


    I am not very experienced with SQL, I only know the some basic things and I need help in writing the code to perform the search (PHP).

    Please help.


    Thank you.

  2. #2
    If you are using MySQL, you have to use something called "full-text" search. Your table must be converted to the InnoDB engine (I think) before using the MATCH and AGAINST functions.

  3. #3
    SELECT * FROM TABLE WHERE field1 LIKE '%keyword%'; it's very easy query. try to understand fulltext after you learned this query

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012