MySQL: Getting&assigning number from a column of strings
<p>The table contains a column that contain strings. I would like to extract numbers from the string.</p>

<p>The code: <a href="http://sqlfiddle.com/#!9/2af45" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/2af45</a></p>

<p>Eg:<br>
1 Day = 1<br>
2 Day anytime = 2<br>
7 Days = 7<br></p>

<p>SameDay = 1<br>
As for string that does not contain any number, I would like to assign a number to it.</p>

<p><strong>What I have in mind</strong>:<br>
<a href="https://i.stack.imgur.com/RKP0l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RKP0l.png" alt="enter image description here"></a></p>

<p>What will be the best solution such that the query will not affect the loading speed greatly on MySQL?</p>

<p><strong>Additional challenge</strong>: If the number appears randomly in the string, is there any method/algorithm that can potentially pull the number?<br>
E.g. every 2 day, promotion in 7 days</p>