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.
3)The query
SELECT meta_value FROM wp_postmeta WHERE meta_key LIKE 'etimeclockwp-in%'
2) the output (this is one column).
1576486935|8
1576141273|21
1574067745|23
3) Sample output after the questioned query :
1576486935
1576141273
1574067745
Thank You.
try provide some sample data and tell us your expected output.