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