# Fulltext doesn´t work for integer?

**URL:** <https://www.ruby-forum.com/t/fulltext-doesna-t-work-for-integer/124527>\
**Category:** Ruby\
**Created:** [December 29, 2007, 9:02pm UTC](https://www.ruby-forum.com/t/fulltext-doesna-t-work-for-integer/124527 "2007-12-29T21:02:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![markthomas](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90db22/32.png) [@markthomas](https://www.ruby-forum.com/u/markthomas)\
**Post date:** [December 29, 2007, 9:02pm UTC](https://www.ruby-forum.com/t/fulltext-doesna-t-work-for-integer/124527/1 "2007-12-29T21:02:38Z")

</div>

I have used the following code:

a1 = “+”  
a2 = “_"  
 @searchstring = params[:searching].gsub(" ", "_ +”)  
@results = Product.find\_by\_sql(“SELECT \* FROM products WHERE MATCH  
(name,sku) AGAINST (’”+a1+@searchstring+a2+"’ IN BOOLEAN MODE) order by  
name desc LIMIT 0,50;")

It works, BUT not for numbers. Any idea why it coesn´t work for numbers?  
If I have example: “this is 34” in the database. It works fine “this  
is”, but as soon as I enter the “34” it shows no results.

Thanks,

Mark