Note:The table itsels is irrelavent to the question and as such it's not posted. (becuase the query is correct).
My question is :
Is there an SQL way to filter (such as regex) only select (not to update the table just display when queried)
out everything after the pipeline.
1) I only want to display/query not update the query results/
Here is the query result (which is working fine and the output is what should be outputed) the "pipe " / "|" delimiter is not another column
I will repeat again so it's not confusing
the "pipe " / "|" delimiter is not another column it's one string.
SELECT meta_value FROM wp_postmeta WHERE meta_key LIKE 'etimeclockwp-in%'
2) the output (this is one column).
3) Sample output after the questioned query :