Oct-08-2022, 07:40 PM
As stated by ncd85430, it's the SQLite engine that interprets the query.
That being said:
like = % for wildcard, for to find 'beautifulsoup' and anything that ends with soup: [inline]where ... like '%soup';[/inline
to find anything that has soup in anywhere in word: where ... like '%soup%'
you can use as many wildcards as necessary, for example:
That being said:
like = % for wildcard, for to find 'beautifulsoup' and anything that ends with soup: [inline]where ... like '%soup';[/inline
to find anything that has soup in anywhere in word: where ... like '%soup%'
you can use as many wildcards as necessary, for example:
Output:select * from county where CountyName like '%Hill%nty%';
CountyId|StateId|StateCd|CountyName|ClassFP
107|05|AR|Phillips County|H1
095|08|CO|Phillips County|H1
057|12|FL|Hillsborough County|H1
017|13|GA|Ben Hill County|H1
147|20|KS|Phillips County|H1
059|26|MI|Hillsdale County|H1
041|30|MT|Hill County|H1
071|30|MT|Phillips County|H1
001|32|NV|Churchill County|H1
011|33|NH|Hillsborough County|H1
071|41|OR|Yamhill County|H1
211|48|TX|Hemphill County|H1
217|48|TX|Hill County|H1