Faraday Blog

UUID

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

How to generate UUID ranges for SQL queries

How to generate UUID ranges for SQL queries

So you've got a table with a UUID [https://en.wikipedia.org/wiki/Universally_unique_identifier] 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-fff

Engineering hacks Oct 13, 2017 | Seamus Abshere
Page 1 of 1

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