Combine Queries with or_where

Explore how to combine Ecto queries using the or_where macro to perform OR conditions instead of the default AND. Understand how to build flexible queries that return results matching any of multiple criteria, enhancing your database querying skills in Elixir.

We'll cover the following...

Ecto combines where clauses with AND
Combine clauses with or_where
Try it yourself

1.Introduction to This Course

2.Part I: Ecto Fundamentals

3.Get Started with Repo

4.Query Your Database

5.Connect Tables to Elixir Structs with Schemas

6.Make Changes with Changesets

7.Make Multiple Changes with Transactions and the Multi Module

8.Make Changes to the Database

Project

9.Part II: Ecto Applied

10.Add Ecto to an Elixir Application Without Phoenix

Project

11.Work with Changesets and Phoenix Forms

12.Test with Sandboxes

13.Create and Use Custom Types

14.Inserting and Updating with Upserts

15.Optimizeing Your Application Design

16.Work with Embedded Schemas

17.Creating Polymorphic Associations

18.Optimize IEx for Ecto

19.Use Schemas Without Tables

20.Tune for Performance

21.Conclusion

Combine Queries with or_where

Ecto combines `where` clauses with `AND`

Combine Queries with or_where

Ecto combines where clauses with AND

Ecto combines `where` clauses with `AND`