Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    4

    Talking Unanswered: query question help

    Hi, I have a address table, I wanna to categorize the address according to their names, for example, any names include 'association', or 'organizaiton', or 'law', the problem is I just query only part of the field item, and these queries may get duplicate records.

    Here is samples of the name field:
    Afrcian Bar Association
    African Association of International Law
    etc.

    Please help me to figure it out, thanks.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    IMHO, the best solution would be to add a "category" field to each address. That way, you can incrementally modify the records according to different business rules.

    Otherwise, I'd use a CASE statement (mysql has CASE, right).

  3. #3
    Join Date
    Oct 2005
    Posts
    4

    thank you marist89, category is fine, but how to descript the name involves "law"?

    thank you marist89, category is fine, but how to descript the name involves for example "law"? Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •