# so the scenario is we have table called employees # in employees table there is column called department # there are different departments are included in table # now we want some department which we dont know how its spelled there so we are just # trying to fetch the data in column which matched or containes # ex: word 'Clothing' is in stored in table but we dont know exactly how data spelled there # so we try to match something like '% clo %' # or 'C% thing %' SELECT * FROM emploees WHERE department like '% thing %'; # or SELECT * FROM employees WHERE department like 'C% thing %';
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter