Faraday Blog
  • Solutions
    • Customer Insight Discovery Understand your customers
    • Optimized Customer Acquisition Acquire the right customers
    • Maximized Customer Value Expand customer lifetime value
    • Personalization at Scale Personalize every experience
    • Location & Market Intelligence Uncover lucrative locations
  • Customers
    • Success stories Case studies and more
    • Direct-to-consumer Innovative, disruptive brands
    • Financial services Banks, CUs, fintech, insurance
    • Home services Energy, security, and more
    • Mobility Future mobility and automotive
  • Platform
    • Overview End-to-end AI platform
    • Reach Predictive targeting
    • Inform Real-time intelligence
    • Monitor Scheduled evaluation
    • Integrations Data in, insights out
    • Identity graph Powerful consumer data
  • Company
    • Overview Who we are
    • Resources Case studies and more
    • Partners Become a partner
    • Privacy What we believe in
    • Our focus Committed to B2C
    • Careers Join the team
    • Contact How to get in touch
  • Log in
  • Get a demo

UUID

Articles related to UUIDs from the team that helps B2C companies build and defend revenue with AI.

13 Oct 2017 • 4 min read

How to generate UUID ranges for SQL queries

So you've got a table with a UUID primary key. How do you search for only 1/4, or 1/8, or 1/128 of it? BETWEEN '00000000-0000-0000-0000-000000000000' AND '3fffffff-ffff-ffff-ffff-ffffffffffff' BETWEEN '40000000-0000-0000-0000-000000000000' AND '7fffffff-ffff-ffff-ffff-ffffffffffff' BETWEEN '80000000-0000-0000-0000-000000000000' AND 'bfffffff-ffff-ffff-ffff-ffffffffffff' BETWEEN 'c0000000-0000-0000-0000-000000000000' AND 'ffffffff-ffff-ffff-ffff-ffffffffffff' And how do you generate those ranges? Here

Read more

Faraday

Solutions
  • Customer Insights Understand your customers
  • Customer Acquisition Acquire the right customers
  • Customer Engagement Expand your customer LTV
  • Personalization at Scale Personalize every experience
  • Location Intelligence Uncover lucrative locations
Customers
  • Direct-to-consumer Brand innovators
  • Financial services Banks, CUs, fintechs
  • Home services Energy, security, & more
  • Mobility Automotive & future tech
Platform
  • Overview End-to-end AI
  • Reach Predictive targeting
  • Inform Real-time scoring
  • Monitor Customer scoring
  • Optimize Automated AI pipeline
  • Integrations & API 260+ connected services
  • Privacy policy
Company
  • Overview Who we are
  • Resources Case studies and more
  • Partners Become a partner
  • Privacy What we believe in
  • Our focus Committed to B2C
  • Careers Join the team
  • Contact How to get in touch
  • Do Not Sell My Info