First page Back Continue Last page Image

REGEXP_LIKE Example Translated

+---------+--------------------------+

| AlbumId | AlbumName |

+---------+--------------------------+

| 1 | Powerslave |

| 2 | Powerage |

| 3 | Singing Down the Lane |

| 4 | Ziltoid the Omniscient |

| 5 | Casualties of Cool |

| 6 | Epicloud |

| 7 | Somewhere in Time |

| 8 | Piece of Mind |

| 9 | Killers |

| 10 | No Prayer for the Dying |

| 11 | No Sound Without Silence |

| 12 | Big Swing Face |

| 13 | Blue Night |

| 14 | Eternity |

| 15 | Scandinavia |

| 16 | Long Lost Suitcase |

| 17 | Praise and Blame |

| 18 | Along Came Jones |

| 19 | All Night Wrong |

| 20 | The Sixteen Men of Tain |

+---------+--------------------------+

SELECT AlbumId, AlbumName

FROM Albums

WHERE REGEXP_LIKE(AlbumName, '^Power');

Result:

+---------+------------+

| AlbumId | AlbumName |

+---------+------------+

| 1 | Powerslave |

| 2 | Powerage |

+---------+------------+

https://database.guide/how-the-regexp_like-function-works-in-mysql/

Look for Album Names Starting with “Power”

Imagine my reaction when the book author used an Iron Maiden Reference