Just putting a note as I have spent ages looking for a solution and getting it to work in my environment.
What?
Need to be able to omit HTML tags in certain fields of a mySQL database.
Why? ...
... PageID,
CONVERT(p.page_title USING latin1) AS PageTitle,
CONVERT(t.old_text USING latin1) AS PageContent,
(SELECT GROUP_CONCAT(CONVERT(wikimedia_categorylinks.cl_to USING latin1)) FROM wikimedia_categorylinks ...
... table for just the name value...
The one query to rule them all
SELECT
CONCAT(s.LogID, ' ') AS ActivityID,
t.TeamName AS Team,
CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName,
CASE ...
... INTO my_wordpress_db.wp_posts
SELECT
id 'ID',
1 'post_author',
created 'post_date',
created 'post_date_gmt',
CONCAT(introtext, ' ', `fulltext`) 'post_content',
title 'post_title',
'' post_excerpt,
CASE ...
... AS lft,
@new_jos_assets_id_last_lft + 1 AS rgt,
2 AS level,
CONCAT(
'com_banners.category.',
@new_jos_assets_last_inc:=@new_jos_assets_last_inc+1
...
... local report processing.
An error has occurred during report processing.
The Group expression used in grouping 'table1_month' returned a data type that is not valid.
My DataSet Query was as follows:
SELECT
CONCAT(MONTHNAME(t1.Date), ...
... 5 columns:
MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user.
SELECT
CONCAT(MONTHNAME(t2.Date), ' ', ...
...
The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases:
SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.