> - This WHERE clause matches MarPlo, marius, Mars, and so on, but not Omar. For example we want to collect all the account numbers ending with 044 in a five digit account number field. sql 'SELECT FROM tablename WHERE name LIKE 'mar'' //. Use of underscore ( ) as wildcard in string matching We can use underscore as wildcard for one character space and use them along with LIKE statement and apply to table columns. Examples of queries with LIKE /NOT LIKE
0 Comments
Leave a Reply. |