Simple search engine with SQL

zhaozj2021-02-16  93

Basic search

Select * from [Table1] Where [Column1] Like '% String1%'

2. Multi-column search

Select * from [table1] where ([Column1] [Column2]) LIKE '% String1%'

3. Multi-valued and search

Select * from [Table1] Where [columnς] Like '% String1% String2%'

4. Multi-valued or search

Select * from [table1] where ([columnς] Like '% stringς1%') or ([columnς] Like '% stringς2%')

Note: Do not have to beware of the English alphabet of the data and the problem of data.

转载请注明原文地址:https://www.9cbs.com/read-11378.html

New Post(0)