MySQL Forums
Forum List  »  Newbie

Re: How do I create rows from an array to create a view in phpMy Admin - mySql
Posted by: Debbie Shaw
Date: December 09, 2021 03:49AM

Thanks for your advice, but I really have no idea what I need to do...

The site is a WordPress based website and a plugin stores multiple dates in a column.

I need to extract these individual dates and join these dates to the bookings so the client can see how many people are travelling on what date.

These dates will be updated on a daily basis so I need to do this on the fly, not create a static one-off table.

If you can give me an idea on the SQL query I need to do that would be very helpful...thanks...

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.