The default search term operator is AND
You can use brackets, AND OR and NOT to improve your search. For example: C# AND NOT ( VB or SQL )
A query of a single * will return everything, filtered by any filters.
Search by Author: author:"author name"
Filter by tag: tag:C# or tag:(C++ or Java)
Wildcard search use: "?" or "*" eg. gr?d or gr*
Transactions allow you to build brackets around multiple statements and is used in INSERTs, UPDATEs, and DELETEs. Martin will show you how to execute this properly in this video.
This video from our "SQL Database for Beginners" series will cover the concept of transactions. You will learn how to apply what you have already been shown in the previous chapters to how to create a transaction, along with the COMMIT and ROLLBACK commands.