Using a LIKE SQL statement in Express/Node

Question

I have a SQL query that I am trying to call that searches for words that match a keyword and then searches within a radius for the results

This query will work but only searches using "LIKE ?" not "LIKE %?%

connection.query("SELECT *, ( 3959 * acos (cos ( radians(?) )* cos( radians( lat ) )* cos( radians( lng ) - radians(?) )+ sin ( radians(?) )* sin( radians( lat ) ))) AS distance FROM job_posting where job_title like ? HAVING distance < 25",
        [lat, lng, lat, keyword], function(error, result) {
        console.log(result)
    })

but I need %% around the keyword value at the end, something like this

job_posting where job_title like %?% HAVING distance < 25"

I can't get it to run the query with the % signs at all. Any tips on how to fix this?

Can't you put the % signs around the keyword before passing it in as a query argument? — Pointy
– Pointy, Commented Nov 27, 2016 at 1:17

bbennett36 · Accepted Answer · 2016-11-27 01:40:31Z

1

var keyword = ("%" + req.query.keyword + "%")

answered Nov 27, 2016 at 1:40

bbennett36

6,39510 gold badges23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using a LIKE SQL statement in Express/Node

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related