Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Searching for words *within* a field
Message
De
31/08/2001 13:58:10
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00551437
Message ID:
00551549
Vues:
24
Vlad,

Why not use a single table that contains:

Word
Link

Where "Link" contains a unique identifier for the record that contains this specific word. You could then use a SELECT such as this:

sele * from musictbl, dict where musictbl.unique_id == dict.linkid and (dict.word = "HOLY" or dict.word = "NIGHT")

Is there some advantage to your approach that I'm not seeing?

Pete
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform