New Metabase 54: Table visualization improvements, smarter custom expression editor, better alerts, and more Read the announcement Chevron Blue Right
Product
Business Intelligence

Self-service analytics for your team

Embed
Embedded Analytics

Fast, flexible customer-facing analytics

Data sources Security Cloud
Features
Analytics dashboards
Query builder
Models
CSV upload
Usage analytics
Sandboxing
Embedded analytics SDK
White-label analytics
Drill-through
SQL editor
Permissions
Collections
What’s new Roadmap
Docs
Documentation

The Metabase manual

Learn icon
Learn

Guides and tutorials

Getting Started

Querying and Dashboards

Everyone exploring and analyzing data

Embedding

Developers building in-product analytics

Administration

People running their company's instance

Guides Installing Metabase Adding a database Asking questions Creating a dashboard Solving common problems
Resources
Blog

News, updates, and ideas

Events

Join a live event or watch on demand

Customers

Real companies, real data, real stories

Discussion

Share and connect with other users

Metabase Experts

Find an expert partner

Community Stories

Practical advice from our community

Recent Blog Posts
Resources Image
Top 5 Dashboard fails (and how to fix them)
Product Hunt AMA Recap: embedding, open source success, and more Introducing Metabase's new Embedded Analytics SDK for React Metabase alternatives: peeking at other Business Intelligence tools Maps data visualizations: best practices
Pricing
Log in Get started
Business Intelligence

Self-service analytics for your team

Embed
Embedded Analytics

Fast, flexible customer-facing analytics

Platform
Data Sources
Security
Cloud
Demo

Watch 5-minute demo

Embedded analytics SDK
White-label analytics
Analytics dashboards
Drill-through
Query builder
SQL editor
Models
Permissions
CSV upload
Sandboxing
Usage analytics
Collections
Updates
What’s new
Roadmap
Documentation

The Metabase manual

Learn

Guides and tutorials

Getting Started

Querying and Dashboards

Everyone exploring and analyzing data

Embedding

Developers building in-product analytics

Administration

People running their company's instance

Guides Installing Metabase Adding a database Asking questions Creating a dashboard Solving common problems
Blog
Events
Customers
Discussion
Metabase Experts
Community Stories
Pricing Log in
Docs Learn
Home
Courses
  • Getting started
    • Find data
    • Ask a question
    • Create a dashboard
    • Explore dashboards
    • Filter and limit data
    • Summarize data
    • Add custom columns
    • Use dashboard filters
    • Build models
Metabase Basics
  • Metabase overview
    • A tour of Metabase
    • Metabase concepts
    • Advanced Metabase features for data analysts
    • Beyond BI: other problems you can solve with Metabase
  • Querying and dashboards
    • Asking questions
      • Create interactive charts
      • Custom expressions
      • Joins in Metabase
      • Combining data from different databases
      • Multi-level aggregation
      • Searching in tables
      • Cleaning and formatting text
    • Visualizing data
      • Which chart should you use?
      • Guide to line charts
      • Master the bar chart
      • Histograms
      • Tables and formatting
      • Pivot tables
    • Building dashboards
      • BI dashboard best practices
      • Linking filters in dashboards
      • Custom click destinations on dashboards
      • Cross-filtering: using a chart to update a dashboard filter
      • Markdown in dashboards
      • Build a record lookup tool with Metabase
    • SQL in Metabase
      • Create filters using SQL variables
      • Field filters for SQL questions
      • Snippets: reuse and share code
      • Snippets vs. Saved Questions vs. Views
      • Adding filters to dashboards with SQL questions
      • SQL trick: ordering bars in a chart
    • Share your work
    • Time series analysis
      • Overview of time series analysis
      • Period-over-period comparisons for time series
      • Best practices for visualizing time series
    • Data reference
    • Build a basic CRUD app with actions
    • Using Metabase with MongoDB
  • Administration
    • Administration and operation
      • Admin overview
      • How Metabase works with your database
      • How to run Metabase in production
      • Managing people in Metabase
      • Guide to sharing data
      • Keeping your analytics organized
      • Multiple environments
      • Serialization: preloading dashboards in a new Metabase instance
      • Setting up a git-based workflow
      • Making dashboards faster
      • Metabase at scale
      • Working with the Metabase API
    • Permissions
      • Permissions strategies
      • Guide to data permissions
      • Working with collection permissions
      • Basic sandboxes: setting row-level permissions
      • Custom sandboxes: limiting access to columns
      • Data sandboxes: personalizing the data that people can see in Metabase
      • Use Impersonation to get row-level permissions with both GUI and SQL queries
      • Configuring multi-tenant data permissions
      • How to keep tabs on your data
      • Using LDAP for authentication and access control
  • Embedding
    • Strategies for delivering customer-facing analytics
    • Publishing data visualizations to the web
    • A Metabase mystery
    • Multi-tenant self-service analytics
    • Brand your Metabase
    • Securing embedded Metabase
Grow your data skills
  • Learn SQL
    • Get started with SQL
      • Introduction
      • SQL querying tables
    • SQL filtering
      • SQL filtering by text
    • Working with SQL
      • Best practices for writing SQL queries
      • Simplify complex queries with Common Table Expressions (CTEs)
      • Working with dates in SQL
      • How to calculate customer lifetime value (LTV) with SQL
      • Combining tables with joins
      • SQL join types
      • SQL syntax reference
    • Debugging SQL
      • Debugging SQL syntax errors
      • Debugging SQL query logic
      • Debugging duplicated data in SQL query results
      • Debugging missing data in SQL query results
  • Database fundamentals
    • A short overview of databases
    • Data types and metadata
    • Database table relationships
    • Measures and dimensions
    • Analytics engineering for fact tables
    • Data normalization
    • What is a database view?
    • Data cubes
  • Data landscape
    • A guide to the data landscape
    • Types of databases
    • Data warehouse vs data lake vs data mart
    • Which data warehouse should you use?
    • ETLs, ELTs, and Reverse ETLs
  • Strategies for analytics
    • Why you should regularly edit your dashboards
    • Managing your information budget
    • Don't use "data" as a crutch for lazy thinking
    • Common data model mistakes made by startups
    • Ten common analytics mistakes startups make
    • The five stages of embedding grief
    • The push and pull of analytics
Cheat sheets
  • Transition from other BI tools
    • Power BI to Metabase
    • Tableau to Metabase
    • Looker to Metabase
  1. Learn
  2. Learn SQL
  3. SQL filtering
What’s new

SQL filtering

SQL filtering by text

Learn SQL text filtering: use WHERE, LIKE, IN, NOT IN, TRIM, UPPER, LOWER, regex, and variables to find and filter string data in tables.

9 min read

Subscribe to our newsletter

Stay in touch with updates and news from Metabase. No spam, ever.

Product
Watch Demo Data Sources Security Cloud Roadmap What's New
Pricing
Plans Open Source
Use Cases
Self-Service Business Intelligence Embedded Analytics
Metabase Plans
Starter and Open Source Pro Enterprise
Features
Query Builder Drill Through Collections Usage analytics Analytics dashboards SQL editor Sandboxing Models Permissions CSV upload Embedded analytics SDK White label analytics
Company
Jobs
We're hiring!
Privacy Policies Terms of Service License Brand Guidelines
Support
Documentation Help Professional Services Onboarding
Status
Github
Resources
Case Studies Blog Learn Community Stories Data and Business Intelligence Glossary Partners The Startup's Guide to Financial Modeling The 2023 Metabase Community Data Stack Report Choosing Metabase
Business Intelligence Business Intelligence for Startups Embedded Analytics Metabase vs. Tableau Metabase vs. Looker Metabase vs. PowerBI Metabase vs. Superset
More Resources
Example Dashboards SQL Best Practices Choosing a Data Warehouse How to Create Pivot Tables Types of SQL Joins SQL Cheat Sheet Data Bias Examples Modern Data Stack Dashboard for Marketing Teams Dashboards for Sales Teams Dashboards for Engineering Teams
© Metabase 2025