Question

在<代码>phpMyAdmin上,有<编码>在数据库上的搜索功能,据此,我可以输入一个词并在任何表格中找到。

How to implement it by SQL statement? I know the LIKE operation, but it s syntax is:

WHERE column_name LIKE pattern

如何搜寻所有栏目? 如何具体指明关键词或定期表述?

Answer 1

SELECT * FROM your_table_name WHERE your_column_name LIKE  search_box_text ;

Where search_box_text is what you enter in the search. It will also say in the result page what kind of query it made. The same query with regular expressions is:

SELECT * FROM your_table_name WHERE your_column_name REGEXP  search_box_text ;

认为我sql的野心是%。 Eg. “LIKE %partial_search_text%

如果你想在多个栏目中搜索,你可以检查哪一栏:

DESCRIBE TABLE your_table_name;

Or if you already know your columns:

SELECT * FROM your_table_name 
WHERE your_column_1 LIKE  %search%  
AND your_column_2 LIKE  %search% 
AND your_column_3 LIKE  %search% ;

友情链接