Databases
StackOverflow2013
Postsdbo
POmatching everything but pre-determined before and after vs
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmatching everything but pre-determined before and after vs
    primarykey
    data
    text
    <p>Examples.</p> <ul> <li>URL PRESENTS MATH HOFFA VS T-REX ROUND 1</li> <li>URL PRESENTS MATH HOFFA VS T-REX ROUND 2</li> <li>URL Presents Young Miles vs Rich Dolarz Round 2</li> <li>SMACK/ URL PRESENTS AYE VERB vs O-RED</li> <li>SMACK/ URL PRESENTS ARSONAL VS CALICOE (FULL BATTLE))</li> <li>SMACK/ URL PRESENTS Rich Dolarz VS X-Factor (FULL BATTLE))</li> <li>GrindTimeNow.NET: Stainless vs 3pfd</li> <li>GrindTimeNow.NET: 5vs5 League Announcement! + 40 city tryout tour!</li> <li>www.GrindTimeNow.NET: Magz vs K-mo (Tryouts)</li> <li>GrindTimeNow.Net: Scotty P vs Farnum Hosted by Murs, Madd Illz and Wordsworth</li> <li>GrindTimeNow.Net: Kaveman Brown vs Real Talk</li> <li>GrindTimeNow.Net:DIRT VS Richard CRANIUM</li> <li>GrindTimeNow.Net:Jonny Storm vs Real Talk (Paid Dues 2012) </li> </ul> <p>I want to match Name vs Name - The string isn't always consistent e.g Grindtimwnow.net, URL PRESENTS and SMACK/ URL PRESENTS - I understand I may need to use up to three different regexs which I can work with. </p> <p>The problem I'm having, having tried the following</p> <pre><code>$ourRegex = "/(\b\w+\W+){0,3}vs(\W+\w+){0,3}/"; $ourRegex = "/:\s+(.+?)\s+Vs\s+(.+)$/"; $ourRegex = '/\s+(.+?)\s+Vs\s+(.+)$/'; </code></pre> <p>Dosen't match all of the contenders name, I get things like Jonny vs Talk - Names can have up to three/four words in them, is there any simple solution or do I need to run several different regexs and build a function to first clean-up the stirng and then regex it?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USLiam Closs
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POmatching everything but pre-determined before and after vs
      1. This table or related slice is empty.
      1. VTDownMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload