(NOT LIKE) Operator Not Working As Expected - How To Use (NOT LIKE) On Semantic Search?

May 9, 2025 by ADMIN 88 views

NOT LIKE Operator Not Working as Expected - How to Use (NOT LIKE) on Semantic Search?

Introduction

Semantic Search is a powerful tool for querying and retrieving data from wikis and other databases. However, it can be challenging to use, especially when trying to exclude specific values or patterns. In this article, we will explore how to use the (NOT LIKE) operator in Semantic Search to exclude "Rush Duel" and "Pendulum" cards from a query.

Background

I am fairly new to Semantic Search, and I am using it in the Yu-Gi-Oh! Wikia to retrieve specific card types. My query is to get all Dinosaur monster cards that belong to the Main Deck and exclude "Rush Duel" and "Pendulum" cards. I have managed to create a condition that retrieves the desired cards, but I am struggling to exclude the unwanted cards.

The Query

My current query is:

[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[Primary type::!~Pendulum Monster]]

This query retrieves all Dinosaur monster cards that belong to the Main Deck and have a primary type that is not a Pendulum Monster. However, I want to exclude cards that belong to the "Rush Duel" or "Pendulum" sets.

The Problem

The problem is that the (NOT LIKE) operator is not working as expected. I have tried using the !~ operator to exclude the unwanted cards, but it is not working. I have also searched the documentation and asked for help on Stack Overflow, but I have not found a solution.

The Solution

After further research, I found that the (NOT LIKE) operator is not supported in Semantic Search. However, there is a workaround using the NOT EXISTS operator. The NOT EXISTS operator returns all values that do not exist in a specific set.

To exclude "Rush Duel" and "Pendulum" cards, we can use the following query:

[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[NOT EXISTS (Primary type::Pendulum Monster)]] [[NOT EXISTS (Belongs to::Rush Duel)]]

This query retrieves all Dinosaur monster cards that belong to the Main Deck and do not have a primary type that is a Pendulum Monster or belong to the "Rush Duel" set.

Conclusion

In conclusion, the (NOT LIKE) operator is not supported in Semantic Search, but we can use the NOT EXISTS operator as a workaround. By using the NOT EXISTS operator, we can exclude specific values or patterns from our query. I hope this article has been helpful in understanding how to use Semantic Search and the NOT EXISTS operator.

Additional Tips and Guidance

Always check the documentation and search for existing solutions before asking for help.
Use the NOT EXISTS operator to exclude specific values or patterns from your query.
Be careful when using the NOT EXISTS operator, as it can return unexpected results if not used correctly.
Practice using Semantic Search and the NOT EXISTS operator to become more comfortable with the tool.

Example Use Cases

Excluding specific values or patterns from a query.
Retrie data that does not exist in a specific set.
Using the NOT EXISTS operator to improve query performance.

Resources

Semantic MediaWiki Documentation: Full-text search/Searching
Semantic MediaWiki Documentation: Search operators
Stack Overflow: How to set the conditionals using Mediawiki's Semantic Search

Contact and User Support

If you have any questions or need further guidance, please do not hesitate to contact me. I am happy to help and provide support. You can reach me through the Yu-Gi-Oh! Wikia or by sending an email to [your email address].
Semantic Search Q&A: NOT LIKE Operator and More

Introduction

Semantic Search is a powerful tool for querying and retrieving data from wikis and other databases. However, it can be challenging to use, especially for those who are new to the tool. In this article, we will answer some frequently asked questions about Semantic Search, including how to use the (NOT LIKE) operator and more.

Q: What is the (NOT LIKE) operator in Semantic Search?

A: The (NOT LIKE) operator is a search operator that returns all values that do not match a specific pattern. However, the (NOT LIKE) operator is not supported in Semantic Search. Instead, we can use the NOT EXISTS operator as a workaround.

Q: How do I use the `NOT EXISTS` operator in Semantic Search?

A: To use the NOT EXISTS operator, you can add the NOT EXISTS keyword followed by the condition you want to exclude. For example:

[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[NOT EXISTS (Primary type::Pendulum Monster)]] [[NOT EXISTS (Belongs to::Rush Duel)]]

This query retrieves all Dinosaur monster cards that belong to the Main Deck and do not have a primary type that is a Pendulum Monster or belong to the "Rush Duel" set.

Q: What is the difference between the `NOT EXISTS` operator and the `NOT IN` operator?

A: The NOT EXISTS operator returns all values that do not exist in a specific set, while the NOT IN operator returns all values that are not in a specific set. For example:

[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[NOT EXISTS (Primary type::Pendulum Monster)]]

This query retrieves all Dinosaur monster cards that belong to the Main Deck and do not have a primary type that is a Pendulum Monster.

[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[NOT IN (Primary type::Pendulum Monster)]]

This query retrieves all Dinosaur monster cards that belong to the Main Deck and are not a Pendulum Monster.

Q: How do I use the `LIKE` operator in Semantic Search?

A: The LIKE operator is used to search for values that match a specific pattern. To use the LIKE operator, you can add the LIKE keyword followed by the pattern you want to search for. For example:

`[[Class 1::Official]] [[Card type::Monster Card]] [[Type::Dinosaur]] [[Belongs to::Main Deck]] [[LIKE (Primary type::%Pendulum%)]]