查询某条记录在mysql中的行数

标签：某条 ------------- 行数 mysql rownum SELECT

查询某条记录在mysql中的行数| Id | Title | DateAdded | SourceUrl | PostType | Body | BlogId | Description | DateUpdated | IsMarkdown | EntryName | CreatedTime | IsActive | AutoDesc | AccessPermission |

| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------|
| 14037530| 查询某条记录在mysql中的行数| 2020-11-25T17:55:00| | BlogPost|

 

select d.rownum from (SELECT *
FROM (SELECT @rownum:=0) c,
(SELECT a.*,@rownum:=IFNULL(@rownum,0)+1 rownum  FROM tableName a ORDER BY a.colName ) b ) d where d.id='keyWord'

| 648658| | 2024-04-29T21:19:00| false| | 2020-11-25T17:55:01.243| true| select d.rownum from (SELECT *FROM (SELECT @rownum:=0) c,(SELECT a.*,@rownum:=IFNULL(@rownum,0)+1 rownum FROM tableName a ORDER BY a.colName ) b ) d w| Anonymous|

标签：某条,-------------,行数,mysql,rownum,SELECT
From： https://www.cnblogs.com/ralphlauren/p/18621327