node-mysql - wildcat search in query

Question

I am building an application that allows users to search for other users by facebookid, email, or fullname and they need only enter a keyword. How do i build the query using connection.query? I use the mysql module. Below is my last try.

connection.query("select * from User where fullname like %? or facebook = ? or email = ? limit 50", keyword, function(err, result){
                                             ...
                                              });

maybe it's easier to use an ORM to do this for you? like sequelize? — Shih-Min Lee, Jul 01 '15 at 02:06
find a clue from post http://stackoverflow.com/questions/17922587/node-mysql-escape-like-statement — Dustin Sun, Jul 01 '15 at 02:25

score 0 · Answer 1 · answered Jul 13 '15 at 13:25

you need to send arguments like following

connection.query("select * from User where fullname like %? or facebook = ? or email = ? limit 50", keyword,keyword,keyword, function(err, result){
                                             ...
                                              });

because you are using '?' three time.hence,making query to take three arguments.

node-mysql - wildcat search in query

1 Answers1