# Searching a table technique

**URL:** <https://forum.kirupa.com/t/searching-a-table-technique/284975>\
**Category:** programming\
**Created:** [March 25, 2009, 6:13pm UTC](https://forum.kirupa.com/t/searching-a-table-technique/284975 "2009-03-25T18:13:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![fido\_glc](https://avatars.discourse-cdn.com/v4/letter/f/3da27b/32.png) [@fido\_glc](https://forum.kirupa.com/u/fido_glc)\
**Post date:** [March 25, 2009, 6:13pm UTC](https://forum.kirupa.com/t/searching-a-table-technique/284975/1 "2009-03-25T18:13:16Z")

</div>

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.