Kusum Kusum - 8 days ago 7
MySQL Question

SQL Like Operator

Expected Output:

enter image description here

How can we run a query that returns "Robot" followed by a year between 2000 and 2099? (So 2015 is a valid value at the end, but 2123 is not.)

enter image description here

Answer

Got the answer:

SELECT id, name FROM robots WHERE name LIKE '%Robot 20%_%'