I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder?
Like enables you to use wildcards, the wildcard depends upon the type of table you are querying see the help topic on queries within Arcmap there is an example there STATE_NAME LIKE 'Miss%' which will find all cases beginning with Miss within a field
The SQL reference is in this link as well.
LIKE is also usually case insensitive.
Of course SQL syntax varies somewhat among data formats and DBMS's. Dan's link has some of those details.
I suggest moving this thread to GIS