| use metawiki_p;
select SUBSTRING_INDEX(page_title, ':', 1) as prefix,
--... |
6 years ago |
| use metawiki_p;
select SUBSTRING_INDEX(page_title, ':', 1)
--... |
6 years ago |
| use metawiki_p;
select page_title, LOCATE(":", page_title)
--... |
6 years ago |
| use metawiki_p;
select page_title, LOCATE(":", page_title)
--... |
6 years ago |
| use metawiki_p;
select page_title, LOCATE(":",page_title)
--... |
6 years ago |
| use metawiki_p;
select SUBSTRING(page_title, 0, LOCATE(":",page_title)) as... |
6 years ago |
| use metawiki_p;
select SUBSTRING(page_title, 0, LOCATE(":",page_title)+1) as... |
6 years ago |
| use metawiki_p;
select page_id, page_title
from page
where page_title like... |
6 years ago |
| use metawiki_p;
select page_id, page_title
from page
where page_title like... |
6 years ago |
| use metawiki_p;
select page_id, page_title
from page
where page_title like "%:%"
|
6 years ago |
| use metawiki_p;
select page_id, page_title
from page
where page_title like "%:%"
|
6 years ago |
