We've also been talking about in organizing this into a SQL-like interface, I th... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ghall on Jan 15, 2020 \| parent \| context \| favorite \| on: A GitHub repo of jobs listings with bounties We've also been talking about in organizing this into a SQL-like interface, I think there could be a lot of value in job hunting in such a manner... "SELECT * FROM jobs WHERE location = 'seattle' and keyword LIKE '%python%'"

yayajacky on Jan 15, 2020 [–]

If the keyword column is a json blob, you might be able to do it with JSON_CONTAINS:

https://dev.mysql.com/doc/refman/8.0/en/json-search-function...

(Unless you are using mongo on the backend, in which case I am not familiar with that)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact