+
Skip to content

creating an alias with the AS operator #37

Closed
@schmeic

Description

@schmeic

How would I do something like this:
SELECT id, body, MATCH (body) AGAINST ('mysql tutorial' IN BOOLEAN MODE) AS score FROM articles HAVING score > 0 ORDER BY score DESC;

  1. How do I create an alias with AS?
  2. How can I use that alias in a HAVING / ORDER BY clause?

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      点击 这是indexloc提供的php浏览器服务,不要输入任何密码和下载