carl123 Posted May 11, 2020 Posted May 11, 2020 The word "from" gives weird results when used in a search of this forum E.g. Searching for... from add from selection convert from colour synchronize defaults from selection All result in no hits when used as above or in a phrase search The only time using the word "from" results in a hit is when it is used at the start of a phrase search. E.g. "from selection" "from colour" Does anyone know why this is? Is the word "from" some sort of a search operator word? Quote To save time I am currently using an automated AI to reply to some posts on this forum. If any of "my" posts are wrong or appear to be total b*ll*cks they are the ones generated by the AI. If correct they were probably mine. I apologise for any mistakes made by my AI - I'm sure it will improve with time.
v_kyr Posted May 11, 2020 Posted May 11, 2020 It might depend on the forums software settings and underlayed MySQL database usage. Beside the fact that the word "from" is in SQL queries used as a keyword, the following applies too ... Quote ... There are three types of full-text searches : Natural Language Full-Text Searches Boolean Full-Text searches Query expansion searches Note: Some words are ignored in full-text searches. The minimum length of the word for full-text searches as of follows : Three characters for InnoDB search indexes. Four characters for MyISAM search indexes. Stop words are words that are very common such as 'on', 'the' or 'it', appear in almost every document. These type of words are ignored during searching. ... See for example: MySQL full text search Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2
R C-R Posted May 11, 2020 Posted May 11, 2020 FWIW, "add to selection" with the quotes will find posts with that phrase in it. Quote All 3 1.10.8, & all 3 V2.5.7 Mac apps; 2020 iMac 27"; 3.8GHz i7, Radeon Pro 5700, 32GB RAM; macOS 10.15.7 All 3 V2 apps for iPad; 6th Generation iPad 32 GB; Apple Pencil; iPadOS 15.7
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.