Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support quantitive LIKE operator syntax #47

Closed
takegue opened this issue Aug 7, 2023 · 0 comments · Fixed by #48
Closed

Support quantitive LIKE operator syntax #47

takegue opened this issue Aug 7, 2023 · 0 comments · Fixed by #48

Comments

@takegue
Copy link
Owner

takegue commented Aug 7, 2023

Operators

  • LIKE ANY
  • LIKE SOME
  • LIKE ALL

https://cloud.google.com/bigquery/docs/reference/standard-sql/operators#like_operator_quantified

Examples

WITH Words AS
 (SELECT 'Intend with clarity.' as value UNION ALL
  SELECT 'Secure with intention.' UNION ALL
  SELECT 'Clarity and security.')
SELECT * FROM Words WHERE value LIKE ANY ('Intend%', '%intention%');
takegue added a commit that referenced this issue Aug 13, 2023
* Resolve #47: Support quantitive like operators

* Update fixtures
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant