select count(*) as 'count'-- get count
from `comment` -- comment table,... |
1 year ago |
select count(*) -- get count
from `comment` -- comment table, escaped with... |
1 year ago |
select count(*) -- get count
from `comment` -- comment table, escaped with... |
1 year ago |
select count(*) -- get count
from `comment` -- comment table, escaped with... |
1 year ago |
select count(*)
from `comment`
where comment_text like '[[WP:AES|←]]%'; |
1 year ago |
select *
from `comment`
where comment_text like '[[WP:AES|←]]%'
limit 1; |
1 year ago |
select *
from `comment`
where comment_text like '[[WP:AES|←]].*'
limit 1; |
1 year ago |
select *
from `comment`
where comment_text regexp '\[\[WP\:AES\|←\]\].*'
limit 1; |
1 year ago |
select count(*)
from `comment`
where comment_text regexp... |
1 year ago |
select count(*)
from `comment`
where comment_text regexp '\[\[WP\:AES\|\←\]\].*'; |
1 year ago |
selct count(*)
from `comment`
where comment_text regexp '\[\[WP\:AES\|\←\]\].*'; |
1 year ago |
selct count(*)
from `comment`
where comment_text like '[[WP:AES|←]]%'; |
1 year ago |