首页sql sever like语句

sql sever like语句

时间: 2023-10-31 10:43:26 浏览: 71

sqlserver语句

1. SELECT * FROM table_name WHERE column_name LIKE '%search_term%' 2. SELECT * FROM table_name WHERE column_name LIKE 'search_term%' 3. SELECT * FROM table_name WHERE column_name LIKE '%search_term' 4. SELECT * FROM table_name WHERE column_name LIKE '[abc]%' 5. SELECT * FROM table_name WHERE column_name LIKE '[^abc]%' 6. SELECT * FROM table_name WHERE column_name LIKE '_bc%' 7. SELECT * FROM table_name WHERE column_name LIKE '%bc_' 8. SELECT * FROM table_name WHERE column_name LIKE 'a%e' 9. SELECT * FROM table_name WHERE column_name LIKE 'a%%e' 10. SELECT * FROM table_name WHERE column_name LIKE 'a%e%'

阅读全文