Kusum Kusum - 1 year ago 224
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 Source

Got the answer:

SELECT id, name FROM robots WHERE name LIKE '%Robot 20%_%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download