# CONTAINS CLAUSE PROBLEM (PHP Version 5.2.10)

**URL:** <https://forum.kirupa.com/t/contains-clause-problem-php-version-5-2-10/314475>\
**Category:** programming\
**Created:** [September 29, 2010, 7:11pm UTC](https://forum.kirupa.com/t/contains-clause-problem-php-version-5-2-10/314475 "2010-09-29T19:11:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![energy](https://avatars.discourse-cdn.com/v4/letter/e/f1d935/32.png) [@energy](https://forum.kirupa.com/u/energy)\
**Post date:** [September 29, 2010, 7:11pm UTC](https://forum.kirupa.com/t/contains-clause-problem-php-version-5-2-10/314475/1 "2010-09-29T19:11:10Z")

</div>

Hi guys,

I am not sure whats wrong with this CONTAINS clause.

EXAMPLE -  
TABLE NAME **scores**

\*\*FIELDS -\> VALUES \*\*  
UserName -\> amep  
VALUE -\> 12

UserName -\> b221  
VALUE -\> 10

I am executing these queries and it is giving me an empty result set :  
SELECT \* from scores WHERE CONTAINS(UserName, ‘am’);  
OR  
SELECT \* from scores WHERE CONTAINS(‘UserName’, ‘am’);  
OR  
SELECT \* from scores WHERE CONTAINS(‘UserName’, ‘“am”’);  
OR  
SELECT \* from scores WHERE CONTAINS(‘UserName’, ‘am\*’);

Shouldn’t this give me a row which has UserName = “amep” …Could somebody figure out whats wrong with these queries?

Thanks.