Python Forum
Python Forum

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
SQL FTS 5
DPaul
Verb Conjugator
Posts: 728
Threads: 116
Joined: Dec 2017
Reputation: 20
#8
May-18-2023, 07:32 AM (This post was last modified: May-18-2023, 07:32 AM by DPaul.)
(May-17-2023, 05:25 PM)DPaul Wrote: Some painstaking tests reveal that I must correct:
- It will find words like ZXXXZ and KYYYX
Correction:
It will NOT find words like ZXXXZ and KYYYX
Gets a bit confusing. Confused
So MATCH does not behave like python "IN <string>" statement.

"ZXXX*" and "KYY*" will be found. But not e.g. "*XXXZ".
More tests needed!
Paul
It is more important to do the right thing, than to do the thing right.(P.Drucker)
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.
Find
Reply


Messages In This Thread
SQL FTS 5 - by DPaul - May-17-2023, 06:12 AM
RE: SQL FTS 5 - by Gribouillis - May-17-2023, 07:34 AM
RE: SQL FTS 5 - by DPaul - May-17-2023, 08:26 AM
RE: SQL FTS 5 - by DPaul - May-17-2023, 09:55 AM
RE: SQL FTS 5 - by Gribouillis - May-17-2023, 10:06 AM
RE: SQL FTS 5 - by Larz60+ - May-17-2023, 11:51 AM
RE: SQL FTS 5 - by DPaul - May-17-2023, 05:25 PM
RE: SQL FTS 5 - by DPaul - May-18-2023, 07:32 AM
RE: SQL FTS 5 - by DPaul - May-19-2023, 05:43 AM
RE: SQL FTS 5 - by Gribouillis - May-19-2023, 06:16 AM
RE: SQL FTS 5 - by DPaul - May-19-2023, 07:09 AM
RE: SQL FTS 5 - by DPaul - May-20-2023, 06:24 AM
RE: SQL FTS 5 - by Gribouillis - May-20-2023, 07:44 AM
RE: SQL FTS 5 - by Larz60+ - May-20-2023, 01:45 PM
RE: SQL FTS 5 - by DPaul - May-20-2023, 05:09 PM

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020