# PHP/MySQL Search?

**URL:** <https://forum.kirupa.com/t/php-mysql-search/217486>\
**Category:** programming\
**Created:** [February 27, 2007, 1:16pm UTC](https://forum.kirupa.com/t/php-mysql-search/217486 "2007-02-27T13:16:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![duncanhall](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@duncanhall](https://forum.kirupa.com/u/duncanhall)\
**Post date:** [February 27, 2007, 1:16pm UTC](https://forum.kirupa.com/t/php-mysql-search/217486/1 "2007-02-27T13:16:13Z")

</div>

So I’m about to start a new project, which will involve a search feature. I’ve made fairly basic searches in PHP / MySQL before using a simple model of something like:  
[COLOR=Black]

```php

SELECT * FROM someTable WHERE field1 OR field2 LIKE '%seach_string%';

```

Obviously this will work, but to a fairly rudimentary level. What I’m looking for is something that can search several fields and return the results ordered to a certain degree of relevancy.

Does anyone know of any good tutorials on creating more advanced search features, or possibly some kind of open source search facility that can be fairly easily tied into a site?

[/COLOR]