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.

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).

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