troubleshooting Question

Filter mysql result after certain text (regex)

Avatar of Web IT
Web IT asked on
MySQL ServerSQL* php mysqli connection
4 Comments1 Solution58 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros