search

max-mapper / sqlite-search

2 stars 1 forks source link

search all columns #4

Open okdistribute opened 9 years ago

okdistribute commented 9 years ago

it might be nice to be able to search all columns for a query. i think this would parse into a SQL OR

okdistribute commented 9 years ago

you can't have multiple MATCH statements so one way to do this is to concatenate the values into a single column which can be MATCHed. example: https://github.com/karissa/dathub/commit/f71ab1c99ed7ca4cd2338f0159169d6b07d69d6b

Should this go into sqlite-search?

blahah commented 8 years ago

Sorry if I'm being dumb, but isn't this what SELECT * ... MATCH query does?

edit: it's not

blahah commented 8 years ago

this line provides all-columns search with an FTS3 virtual table: https://github.com/maxogden/sqlite-search/blob/master/index.js#L117

I guess this was added after the issue was created, so I withdraw my previous comment (which was absurdly wrong in any case) :)