This is an idea I've been developing in my mind.
Sa you have a pretty complex SQL SELECT clause and/or WHERE clause:
SELECT
IF(LEN(CONCAT(FirstName,' ',LastName))>25,'Long','Short') AS NameType
FROM
tablea, tableb
WHERE
[complex where clause here]
In the case of the complex select field, my FUNCTIONS are:
IF()
LEN()
CONCAT()
my fields used are:
FirstName
LastName
and all the rest is strings.
Is there any feature to 100% reliably parse this out? I'm sure I can do it myself using regex, but I don't want to reinvent the wheel.
I mention this because phpMyAdmin, when you do a SQL query in the text area, will show your text parsed and color-coded; except for the annoying line breaks where I don't want, it's 99.99% accurate. Are they using a function of PHP or mySQL to do this?
Thanks many,
Sam
