![]() ![]() Postgres-# WHERE country_name SIMILAR TO '%(k|y)%'='t' If we want to extract those rows which contain the country_name with the letter 'k' or 'y' in any position from countries table, the following statement can be used. Postgres-# WHERE country_name SIMILAR TO '%(y|l)'='t' If we want to extract those rows which contain the country_name ending with the letter 'y' or 'l' from countries table, the following statement can be used. Postgres-# WHERE country_name SIMILAR TO 'Italy'='t' ![]() If we want to extract those rows which contain the country_name 'Mozhe' from countries table, the following statement can be used. Postgres-# WHERE country_name SIMILAR TO 'M%'='t' If we want to extract those rows which contain the country_name starting with the letter 'M' from countries table, the following statement can be used.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |