So I have MySQL Workbench, and the "world" database that comes with it as sample data. Now I have to find all countries that has the letter "W" as the middle character in the land codes in the database.
SELECT Code (with letter W as middle character)
How could I do this?
Of course, I guess I took for granted that "land codes" are always three characters.
if it's a three-character code, yes, that'll do it
but we didn't know what size it was, did we, which is why i asked for a SHOW CREATE TABLE
could you please do a SHOW CREATE TABLE for the country table
Home ... work?
I guess it could be done with '%W%' or similar, but thanks anyway.
SELECT Name, Code
WHERE Code like '_W_'