how to search for exact string in Ruby

Question

what is the Ruby code equivalent to following mysql query? I'm trying to search for an exact match of a string eg.'MAIN' and 'Main' should be treat different.

SELECT UserID FROM sys_users WHERE BINARY UserID='MAIN'

What gem are you using for searching(thinking sphinx/sunspot solar)? — Tauqeer Ahmad, May 21 '13 at 10:08

score 2 · Accepted Answer · answered May 21 '13 at 10:03

2

It's just like:

SysUser.select('UserID').where('BINARY UserID=?', 'MAIN')

answered May 21 '13 at 10:03

xdazz

158,678
38
247
274

score 0 · Answer 2 · edited May 23 '17 at 12:26

A very quick look at ActiveRecord guide gives the answer:

2.1 Pure String Conditions If you’d like to add conditions to your find, you could just specify them in there, just like Client.where("orders_count = '2'"). This will find all clients where the orders_count field’s value is 2.

You could have easily found this through google...

Also, case sensitivity is not Rails responsibility but depends on your database settings. Hint: You should switch default collation to UTF-8.

score 0 · Answer 3 · answered May 21 '13 at 09:58

0

Ruby code equivalent to mysql query:

SysUser.where("UserID='MAIN'").select('UserID')

answered May 21 '13 at 09:58

Deepika

826
6
14

how to search for exact string in Ruby

3 Answers3