Thursday, 3 December 2015

48_SQL_QUERY_LIKE

LIKE Concept


1) Modify some record in our tbl_user table.



Here in the above example we have use the WILD CARD %PARMAR, that means display those record who’s ending is PARMAR.


2) Another example of %.



It will display those record which contain “A”.





DISPLAY THODE RECORD WHICHI CONTAIN HARSHIDA _ARMAR (_ may contain anything, check out the above example.)

No comments:

Post a Comment