hey guys, I'm trying to do a text search on my dat...
# help
p
hey guys, I'm trying to do a text search on my database but I'm not getting the results I need I have a "Post" with a title colum and I store german words in there say I have this title "Ernährung bei einem hohen Cholesterinwert" I tried this statement right here
Copy code
sql
select * 
from "Post"
where 
  to_tsvector('german', title) 
  @@ to_tsquery('german', 'chol');
but I'm not getting any results, any idea why?
n
Hello @philbookst! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
g
n
philbookst (2022-04-10)
p
oh that worked, thank you! do you know if there's a better way for a title search functionality? some kind of fuzzy search maybe - but i cant find any info on how to do it with german words 😦
g
Probably need to Google posgtres and text search, maybe German.... This was a more detail discussion here on ways to search text: https://discord.com/channels/839993398554656828/903770142465466408