# Displaying only titles that starts with a defined caracter

**URL:** <https://www.ruby-forum.com/t/displaying-only-titles-that-starts-with-a-defined-caracter/85801>\
**Category:** Rails\
**Created:** [March 23, 2006, 6:09am UTC](https://www.ruby-forum.com/t/displaying-only-titles-that-starts-with-a-defined-caracter/85801 "2006-03-23T06:09:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![weirdmonkey](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/b782af/32.png) [@weirdmonkey](https://www.ruby-forum.com/u/weirdmonkey)\
**Post date:** [March 23, 2006, 6:09am UTC](https://www.ruby-forum.com/t/displaying-only-titles-that-starts-with-a-defined-caracter/85801/1 "2006-03-23T06:09:15Z")

</div>

Hi,

I would like to know how to display only titles of products that starts  
with a defined letter (ie: titles that begin with A)

Here is the method that I use to place all titles in alphabetical order:

class Livre \< ActiveRecord::Base  
validates\_presence\_of :titre;

```
def self.alpha
    find( :all,
            :order => "titre ASC"
            )
end

```

end

Any ideas ?

Thank you!

---

<div class="post-metadata">

**Author:** ![weirdmonkey](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/b782af/32.png) [@weirdmonkey](https://www.ruby-forum.com/u/weirdmonkey)\
**Post date:** [March 23, 2006, 6:25am UTC](https://www.ruby-forum.com/t/displaying-only-titles-that-starts-with-a-defined-caracter/85801/2 "2006-03-23T06:25:44Z")

</div>

What about

def self.alpha( letter = nil )  
find :all, :order =\> “titre ASC”, :conditions =\> “titre LIKE  
‘#{letter}%’”  
end

That is assuming your using mysql

---

<div class="post-metadata">

**Author:** ![weirdmonkey](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/b782af/32.png) [@weirdmonkey](https://www.ruby-forum.com/u/weirdmonkey)\
**Post date:** [March 23, 2006, 6:27am UTC](https://www.ruby-forum.com/t/displaying-only-titles-that-starts-with-a-defined-caracter/85801/3 "2006-03-23T06:27:20Z")

</div>

On 3/23/06, weirdmonkey [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> ```
> def self.alpha
> find( :all,
> :order => "titre ASC"
> )
> end
> 
> ```
> 
> end
> 
> Any ideas ?
> 
> Thank you!

How about?

class Livre \< ActiveRecord::Base  
def self.beginning\_with(prefix)  
clause = prefix + ‘%’  
find(:all, :conditions =\> [“titre like ?”, clause], :order =\> “titre  
ASC”)  
end  
end

Livre.beginning\_with(‘A’)