Guest User

Untitled

a guest
Mar 13th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. def self.match(msg, set = :all)
  2. find(set, :conditions => ["match(name, nicknames) against (?)", msg])
  3. end
  4.  
  5.  
  6.  
  7. Venue Load (0.001132) SELECT * FROM `venues` WHERE (match(name, nicknames) against (' at jo\'s cafe'))
  8. Venue Columns (0.002631) SHOW FIELDS FROM `venues`
  9. Venue Load (0.000000) Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '114526,17905)) LIMIT 1' at line 1: SELECT * FROM `venues` WHERE (match(name, nicknames) against (51260,114526,17905)) LIMIT 1
  10. EXCEPTION Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '114526,17905)) LIMIT 1' at line 1: SELECT * FROM `venues` WHERE (match(name, nicknames) against (51260,114526,17905)) LIMIT 1
Add Comment
Please, Sign In to add comment