- 0
[mysql] fulltext across multiple tables
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Posts
-
By Yonah · Posted
Sayan Sen, do you think one day an image of the Windows Vista desktop or the wallpaper could be used in the primary image of an article? (When I think of CDs and DVDs I think of that release of Windows and of earlier releases; it is the one that debuted IMAPI 2.0 and other features.) -
By +Eternal Tempest · Posted
Big fan of EAC Here's a good non-default naming scheme I found on the web (can't take credit) File Name Scheme - %albumartist%\%year% - %albumtitle%\%tracknr2% %title% Various Artists Naming Scheme - Various Artists\%year% - %albumtitle%\%tracknr2% %title% Also, I need test but there is a new flac.exe binary & dll you can drop in the folder to upgrade flac support. I did this pre EAC 1.8. EAC 1.8 did upgrade it to 1.4.3. Flac 1.5.0 came out this year. https://ftp.osuosl.org/pub/xiph/releases/flac/ I don't know how much of a difference / impact will make. -
By goretsky · Posted
Hello, Probably the simplest way of doing this would be to add a video card to your computer. Regards, Aryeh Goretsky -
By +Eternal Tempest · Posted
Check out Lisa Melton's GitHub transcoding scripts https://github.com/lisamelton/video_transcoding -
By pradeepviswav · Posted
ChatGPT's Advanced Voice Mode gets a significant update to make it sound more natural by Pradeep Viswanathan OpenAI introduced Advanced Voice Mode last year alongside the launch of GPT-4o. This feature uses natively multimodal models, such as GPT-4o, and can respond to audio inputs in as little as 232 milliseconds, with an average of 320 milliseconds, similar to human response time in a typical conversation. It can also generate audio that feels more natural, pick up on non-verbal cues, such as the speed you’re talking, and respond with emotion. Early this year, OpenAI released a minor update to Advanced Voice Mode that reduced interruptions and improved accents. Today, OpenAI has launched a significant upgrade to Advanced Voice Mode, making it sound even more natural and human-like. Responses now feature subtler intonation, realistic cadence—including pauses and emphasis—and more accurate expressiveness for certain emotions such as empathy and sarcasm. This update also introduces support for translation. ChatGPT users can now use Advanced Voice Mode to translate between languages. Simply ask ChatGPT to start translating, and it will continue translating throughout the conversation until instructed to stop. This feature effectively replaces the need for dedicated voice translation apps. For now, the updated Advanced Voice Mode is available only to ChatGPT paid users. OpenAI also noted that there are some known limitations with this latest update, outlined below. This update may occasionally result in minor reductions in audio quality, such as unexpected variations in tone and pitch—especially noticeable with certain voice options. OpenAI expects to improve audio consistency over time. Rare hallucinations in Voice Mode still persist, sometimes producing unintended sounds resembling ads, gibberish, or background music. While some minor limitations remain, the steady stream of improvements points to a future where the line between human and AI conversation becomes increasingly indistinguishable.
-
-
Recent Achievements
-
maimutza earned a badge
Week One Done
-
abortretryfail earned a badge
Week One Done
-
Mr bot earned a badge
First Post
-
Bkl211 earned a badge
First Post
-
Mido gaber earned a badge
One Year In
-
-
Popular Contributors
-
Tell a friend
Question
+Nik Louch Subscriber²
I am writing a search tool to search our product inventory. The relevant parts of the database structure are:
TABLE products
--product_ID (integer)
--product_name (varchar50)
--product_shortDescription (varchar255)
--product_MRNumber (varchar50)
TABLE productDescriptions
--description_ID (integer)
--product_ID (integer)
--description_text (text)
TABLE productReviews
--review_ID (integer)
--product_ID (integer)
--review_text (text)
The JOINs are kinda obvious, but the products table JOINS against both productDescriptions and productReviews on the product_ID field. Currently this is a one-to-one relationship (reviews will become one to many later, will add a user_ID field and have many reviews by many users against a single product - but that is not for now).
The fields I want to search on are:
products.product_name
products.product_shortDescription
products.product_MRNumber
productDescriptionsdescription_text
productReviewsreview_text
I have performed the following to create the FULLTEXT indices, all of which returned no errors:
However, things are NOT going well...
Firstly, if I perform the following, I get an error "Can't find FULLTEXT index matching the column list":
My GUESS is that this is down to the product_shortDescription field not being TEXT but rather VARCHAR - so no FULLTEXT can actually be applied? If so, suggestions appreciated. This shortDescription is just a very short one line description used more as a quick identifier than a full-on description.
Secondly, I am finding that certain searches are producing no results when they should be returning at least one item. For example, the following returns an empty set:
whereas this returns 7 rows:
What am I doing wrong? I would appreciate any help - sorry if I come across "noob" - I have used FULLTEXT before in MS SQL, but not within MySql...
Link to comment
https://www.neowin.net/forum/topic/844252-mysql-fulltext-across-multiple-tables/Share on other sites
9 answers to this question
Recommended Posts